Without a macro you can use Find and replace. Enter the character you want
to delete in the Find field and leave the Replace field blank.



"DEI" wrote:

Anyone have a macro that will remove spaces (no matter where) and remove
parenthesis? I have some phone numbers I need to remove everything but the
number.