How to Remove Special Characters in Excel

You can use the following formula to remove special characters from a cell in Excel: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,”!”,””),”@”,””),”#”,””), “$”, “”), “%”, “”), “^”, “”), “&”, “”), “*”,…