Log in


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 © 2019 PromoNet Ltd | This email address is being protected from spambots. You need JavaScript enabled to view it.

Registered in England and Wales Company Number: 08456645 - Registered for VAT: No GB170189410