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?

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?

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

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?