Remove Dashes from Social Security Numbers

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
=SUBSTITUTE(A1,"-","")

and format as 0000000000

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
=SUBSTITUTE(A1,"-","")

and format as 0000000000

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Edit | Replace | Find What:- | Replace With: "leave it blank" | click Replace
All
Format | Cells | Number tab | Custom | Enter 000000000
 
Edit | Replace | Find What:- | Replace With: "leave it blank" | click Replace
All
Format | Cells | Number tab | Custom | Enter 000000000
 
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...
 
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...
 
Back
Top