Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i remove telephone number hyphens from a list in Excel?
I have a long list of telephone numbers in an Excel spreadsheet that i need
to remove the hyphons from. Do you have a quick formula for doing this? |
#2
|
|||
|
|||
how do i remove telephone number hyphens from a list in Excel?
One way is to highlight the column, then do Edit Replace put - in the
"Replace" box and leave the "replace with" box empty, then press ReplaceAll Vaya con Dios, Chuck, CABGx3 "Mediazoo" wrote: I have a long list of telephone numbers in an Excel spreadsheet that i need to remove the hyphons from. Do you have a quick formula for doing this? |
#3
|
|||
|
|||
how do i remove telephone number hyphens from a list in Excel?
=SUBSTITUTE(A1,"-","")
-- HTH RP (remove nothere from the email address if mailing direct) "Mediazoo" wrote in message ... I have a long list of telephone numbers in an Excel spreadsheet that i need to remove the hyphons from. Do you have a quick formula for doing this? |
#4
|
|||
|
|||
how do i remove telephone number hyphens from a list in Excel?
If the cells are formatted using the special Phone Number format [<=9999999]###-####;(###) ###-#### and assuming there is 3 digit area code so your numbers currently look like: (781) 555-4444 You can change the format to: ####### This will result in 7815554444. If you are not using an area code 555-4444 it will result in 5554444 Just select the entire column, change the cell format and they should all change. Not sure how to do it if they were not formatted as the Special Phone Number format. Cheers, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=482002 |
#5
|
|||
|
|||
how do i remove telephone number hyphens from a list in Excel?
If not in Special Phone number format for number including area code (781-575-5555) use: =LEFT(J14,3)&MID(J14,5,3)&RIGHT(J14,4) If no area code then: +LEFT(J14,3)&RIGHT(J14,4) J14 represents the cell with the current hyphenated phone number in it. Cheers, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=482002 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
How can I get Excel to find the first number in a list greater tha | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Remove drop-down list in Excel | Excel Discussion (Misc queries) | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) |