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

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

Hemi,

Assume you SS number is in cell A1. Put this in A2:
=SUBSTITUTE(A1,"-","")

This should do it.


"Hemi" wrote:

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

Select the range and use
edit|replace
what: - (that dash)
with: (leave blank)
replace all



Hemi wrote:

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

--

Dave Peterson

I think the other posts have probably answered your question, but it could be
that someone formatted the cells, using the special number format for social
security numbers. In that case, just change the formating.

"Hemi" wrote:

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