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

  • Thread starter Thread starter Guest
  • Start date Start date
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!
 
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
 
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
MS Word 2010 Wildcards 0
formatting a column 4
Formatting Telephone Number Question 2
Preserve format, right tab using concatenate 1

Back
Top