
Excel Formula to Replace all the Special Characters in a Cell
This formula uses regular expressions to replace all special characters by only allowing a-z A-Z and 0-9 and spaces. You can add more exclusions by putting them into the [] square brackets. Just change A1 to the cell you have in your sheet.
=REGEXREPLACE(A1,"[^A-Za-z0-9 ]","")