In this video I demonstrate how to quickly remove special characters - @~#%$ etc from a text string in Excel. I use Power Query to achieve this. If you have Excel 2010 or 2013 you can download Power Query add-in here https://www.microsoft.com/en-gb/download/details.aspx?id=39379. If you have a later version of Excel, Power Query is pre-installed.

This video will be useful if you have the following queries:

How do I remove unwanted characters in Excel?
How do I remove non-alphanumeric characters in Excel?
How do I remove symbols from Excel cells?
------------------------