| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I delete dashes from a phone number xxx-xxx-xxxx in Excel?
How do I delete dashes from a phone number xxx-xxx-xxxx in Excel?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I delete dashes from a phone number xxx-xxx-xxxx in Excel?
With a formula its SUBSTITUTE(A1,"-","") where xxx-xxx-xxxx is in cell A1 ARADER wrote: How do I delete dashes from a phone number xxx-xxx-xxxx in Excel? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I delete dashes from a phone number xxx-xxx-xxxx in Excel?
Select the range
edit|replace what: - (dash) with: (leave blank) replace all You may want to give the number a custom format: 0000000000 ARADER wrote: How do I delete dashes from a phone number xxx-xxx-xxxx in Excel? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I delete dashes from a phone number xxx-xxx-xxxx in Excel?
EditReplace should do it.
Just make note that if first digit is a zero, it will go missing. 049-123-4567 will change to 491234567 Gord Dibben MS Excel MVP On Fri, 16 Feb 2007 09:40:33 -0800, ARADER wrote: How do I delete dashes from a phone number xxx-xxx-xxxx in Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove the ( ) & dashes from column of phone # | Excel Worksheet Functions | |||
| How do I change phone numbers from "xxxxxxxxxx" to "xxx-xxx-xxxx | Excel Worksheet Functions | |||
| change dots to dashes in an account format (xx.xxxx.xxxx) to xx-xx | Excel Discussion (Misc queries) | |||
| removing dashes from phone numbers | Excel Discussion (Misc queries) | |||
| How do I delete the "=" from a cell to give me the phone number I. | Excel Discussion (Misc queries) | |||
Linear Mode
