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 ]","")

Copyright © 2020 PromoMagic Ltd | +44 (0)1795859639 | This email address is being protected from spambots. You need JavaScript enabled to view it.

Registered in England and Wales Company Number: 11970723 -