remove dashs from social security numbers

J

Jim May

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
 
A

Art

Hemi,

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

This should do it.
 
D

Dave Peterson

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

Jonathan Cooper

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

Remove numbers from brackets 0
Working with social security numbers 4
Need to change numbers with dashes to numbers with no dashes 3
Preformatting Excel Prior to Opening Spreadsheet 1
Duplicate enteries 4
How to remove dashes in Social Security number 15
Remove checked items from To Do lists 0
how to reformat numbers 4

Top