worked like a champ guys! Thanks a million!

"Per Jessen" wrote in message
...
Hi
No macro needed, use Find/Replace.

Select target range.

Goto Edit Find Check Replace In the Find Field enter left or right
paranthes or space in Replace Field enter nothing Replace all.

Regards,
Per

"DEI" skrev i meddelelsen
...
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.