Archive of Mr Excel Message Board

remove dashes in ss# in cells

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

Check out our Excel Resources

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

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

Re: remove dashes in ss# in cells

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.