removing dashes from SSN

  • Thread starter Thread starter Ken
  • Start date Start date
If you want to do this with a formula, you can also use

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

which saves a bit of typing <g>.
 
You must log in or register to reply here.

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

Date is backwards 20090123 7
Need to change numbers with dashes to numbers with no dashes 3
Value manipulation complications 5
Extract SSN's from a free form text field... 3
Formatting the SSN 9
Preserve cell formatting as SSN 2
How do I add a 0 and 2 dashes to a truncated soc. sec.# in a cell 10
Can't figure this out 1

Back
Top