I need to make 111-11-1111 into 111111111

[Guest]

I have a spreadsheet that was sent to me that has social security #'s in a
111-11-1111 format. I need to make it a 111111111 format. I just just
wondering what formula I could use to get rid of the hyphens.

 

[Anne Troy]

No formula necessary. Select the column, hit Ctrl+H, enter a hyphen in the
find, and don't put anything in the replace with; replace all.
************
Anne Troy
www.OfficeArticles.com

 

[Alan]

=SUBSTITUTE(A1,"-","")
or just use Edit > Replace > Replace What > - > Replace with > Nothing >
Replace All,
Regards,
Alan.