MrExcel Consulting
Your One Stop for Excel Tips & Solutions

remove dashes in ss# in cells


Posted by brb on February 05, 2002 11:12 AM

I have a large spreadsheet that I need to remove dashes from a series of SS#'s, ex 454-23-9558 to 454239558.
Thanks

Posted by Steve Hartman on February 05, 2002 11:19 AM

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

Posted by IML on February 05, 2002 11:21 AM

First change the format to general to make sure the dashes are really in there, and it is not a custom format.
If they remain, you could use
=SUBSTITUTE(A1,"-","")
assuming your list starts in A1 and copy it down. you could then copy paste special values and delete column A.

good luck

Posted by Mark W. on February 05, 2002 11:23 AM

1. Format your SSN's as Text
2. Choose the Edit | Replace... menu command and
replace "-" with nothing.