How do I change phone numbers from "xxxxxxxxxx" to "xxx-xxx-xxxx

G

Guest

I am combining three databases on Xcel. Total of 18,000 items/contacts.
Approximately 5,000 show a phone number of "xxxxxxxxxx" which will be
incompatable with the remaining items/contacts that have the phone number
listed as "xxx-xxx-xxxx". I like the latter format. How do I change the
list of 5,000 to "xxx-xxx-xxxx"? I have Excel 2002

Simple question, but I am stuck.

Thanks for your help.

Frank
 
A

Anne Troy

Select the column, and hit Find/Replace (Ctrl+H). Type a hyphen in the Find
What box. Don't put anything in the Replace with box, and hit Replace all.
Now, all cells are xxxxxxxxxx. So format the column by Format-->Cells, and
choose Special and choose phone number.
*******************
~Anne Troy

www.OfficeArticles.com
 

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

Similar Threads

How do I delete dashes from a phone number xxx-xxx-xxxx in Excel? 3
Format phone numbers to resemble the (xxx) xxx-xxxx 1
How do I changet a text telephone number (xxx) xxx-xxxx to xxxxxx. 2
Change existing phone numbers from xxx-xxx-xxxx to (xxx) xxx-xxxx format? 4
How do I automatically format the phone number? 2
Here we are with the phone numbers again. I need to convert 7
Bulk standardization/normalization of Oulook Phone numbers 2
how do I set up format for phone numbers, parentheses vs dashes 2

Top