Using a helper column enter =SUBSTITUTE(A1,"-","") and copy down
Then, Copy this new column to itself using paste-special Values, then
Delete Original SS# with the Dashes


in article , Hemi at
wrote on 12/18/08 3:57 PM:

is there a way to remove dashs out of the social security number is excel
spreedsheet