remove dashs from social security numbers
 

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

remove dashs from social security numbers
 

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

remove dashs from social security numbers
 

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

remove dashs from social security numbers
 

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

remove dashs from social security numbers
 

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