Jean

With a helper column try =SUBSTITUTE(E6,"-","")

Regards
Peter

"Jean" wrote:

How do I change social security numbers to leave out the dashes?