Hi, With SSN in A1 try this in B1: =LEFT(A1,3)&MID(A1,5,2)&RIGHT(A1,4)
M Myrna Larson Sep 18, 2004 #2 If you want to do this with a formula, you can also use =SUBSTITUTE(A1,"-","") which saves a bit of typing <g>.
If you want to do this with a formula, you can also use =SUBSTITUTE(A1,"-","") which saves a bit of typing <g>.
