How do I delete dashes from a phone number xxx-xxx-xxxx in Excel?

D

Dave Peterson

Select the range
edit|replace
what: - (dash)
with: (leave blank)
replace all

You may want to give the number a custom format: 0000000000
 
G

Gord Dibben

Edit>Replace 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
 

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

Top