remove dashs from social security numbers

  • Thread starter Thread starter Hemi
  • Start date Start date
Using a helper column enter =SUBSTITUTE(A1,"-","") and copy down
Then, Copy this new column to itself using paste-special Values, then
Delete Original SS# with the Dashes
 
Hemi,

Assume you SS number is in cell A1. Put this in A2:
=SUBSTITUTE(A1,"-","")

This should do it.
 
Select the range and use
edit|replace
what: - (that dash)
with: (leave blank)
replace all
 
I think the other posts have probably answered your question, but it could be
that someone formatted the cells, using the special number format for social
security numbers. In that case, just change the formating.
 

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
Unformating social security numbers 4
How to remove dashes in Social Security number 15
how to reformat numbers 4
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
How do I format a social security number to have no dashes? 5
How do I change a social security number to a number series? 4
Dash in format 4

Back
Top