In Excel, change phone from 555-555-5555 to 5555555555?

G

Guest

I am trying to change data listed in a phone number style of 555-555-5555. I
need to eliminate the "-" so that the cells look like this: 5555555555.
Thanks!
 
A

Anne Troy

It depends. If the hyphens are due to cell formatting, just change the
format of the cells by going to Format-->Cells and choose Text instead of
Phone number. If there are hyphens in the cells, just select the column and
hit Ctrl+H. Type a hyphen into the Find What box, and don't put anything in
the Replace with box, and hit Replace all.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com
 
D

doltish

Simply select the column that has hte phone numbers in it, go to Edit
then Find...

In the Find window hit hte Replace button. This will allow you t
replace the "-" character with nothing
 

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

remove text with format code for phone numbers 4
Finding a Name on a list and returning all matching rows 2
Removing parentheses in a phone number 7
Format Outlook 2003 Contact Phone Numbers 4
Transpose Issue from Columns to Rows... 4
Preserve format, right tab using concatenate 1
Problem with Formatting Phone Numbers in Word 2003 2
making a phone number to be just 10 numbers 5

Top