Remove Dashes from Social Security Numbers

G

Guest

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)
 
B

Bob Phillips

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

and format as 0000000000

--
HTH

Bob Phillips

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

Guest

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

Guest

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

Guest

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...
 
G

Guest

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

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

Top