The ability to clean data is one of the most valuable skills for any data analyst.
Here is one method using formulas.
Learn 3 more ways how to clean any special character from a string.
crispexcel.com/how-to-remove-any-special-character-from-a-string