Need to remove spaces from phone numbers in word document.

G

Guest

I have a list of over 10,000 phone numbers that I need to remove the spaces
from. Example ( 888 555 1212) to (8885551212).

888555 1212
888555 1213

I need to get rid of that space with out doing it manually.

NOTE: I am the phone company and they are only our customer numbers, no
telemarketer here.
 
J

Jay Freedman

Use a wildcard replacement (as explained at
http://www.gmayor.com/replace_using_wildcards.htm). Search for

([0-9]{3}) ([0-9]{3}) ([0-9]{4})

and replace it with

\1\2\3

You may have to run two or more separate searches if some of the
numbers have already had some of the spaces removed.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top