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