Home |
Search |
Today's Posts |
#1
|
|||
|
|||
In Excel, change phone from 555-555-5555 to 5555555555?
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! |
#2
|
|||
|
|||
use =SUBSTITUTE(A1,"-","") or find and replace - with ""
"TJMAURO" wrote in message ... 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! |
#3
|
|||
|
|||
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 "TJMAURO" wrote in message ... 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! |
#4
|
|||
|
|||
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 to replace the "-" character with nothing. -- doltish ------------------------------------------------------------------------ doltish's Profile: http://www.excelforum.com/member.php...o&userid=24799 View this thread: http://www.excelforum.com/showthread...hreadid=383576 |
#5
|
|||
|
|||
Try the Substitute function
=SUBSTITUTE(A1,"-","") HTH RES |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
how to change range for dynamic chart in excel 2000 with button? | Charts and Charting in Excel | |||
Excel renames sheet (repaired) when trying to change data from a . | Excel Worksheet Functions | |||
how do I change an excel template into a "workbook" | Excel Discussion (Misc queries) | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel |