Removing Dashes

J

Jeanette

I wanted to know if anyone knew how to remove
dashes say from a SS# or a phone number
without retyping all the numbers?
 
G

Gary''s Student

Say your data is in A1. In another cell:

=SUBSTITUTE(A1,"-","")

You can then copy this cell and paste/special/value back onto A1
 

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

Similar Threads

Need to change numbers with dashes to numbers with no dashes 3
Autocorrection pecularity 1
How do I create a formula to remove dashes? 6
Phone Number Excel 2003 9
dashes around cells 3
Removing Interpuncts or Mid-dots between syllables 0
Can you have text greyed out as a background in a single cell 1
formatted to place dashes within numbers formatted as text 1

Top