Remove Dashes from Social Security Numbers

C

catrose

How do I remove the dashes from SSN's on a spread sheet? They are NOT setup
as '111-11-1111 I also have a lot of SSN's that start with 00X-XX-XXXX
and I still need the 0's (zeroes) to show.
 
B

Bob Phillips

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

and format as 0000000000

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
N

Nobody

Edit | Replace | Find What:- | Replace With: "leave it blank" | click Replace
All
Format | Cells | Number tab | Custom | Enter 000000000
 
C

catrose

That worked perfectly. Thank you!!!!

Nobody said:
Edit | Replace | Find What:- | Replace With: "leave it blank" | click Replace
All
Format | Cells | Number tab | Custom | Enter 000000000
Click to expand...
 

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

How to remove dashes in Social Security number 15
Remove dashes from phone numbers in a spreadsheet 3
Removing Characters 2
social security numbers 4
How do I format a social security number to have no dashes? 5
Removing dashes from ISBN's while still keeping 1st number (zero) 3
format social security number 2
Working with social security numbers 4

Top