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

Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Working with social security numbers 4
Preformatting Excel Prior to Opening Spreadsheet 1
Need to change numbers with dashes to numbers with no dashes 3
getting unicode to convert from PC to MAC 3
Old digital copier machines store what was copied on an internal hard drive! 8
Duplicate enteries 3
News WhatsApp and Facebook will not remove fake news 8

Top