That's the one !!!! I just switched the A1 and B1, Thank you. The REPLACEHi,
It sounds to me like your SSNs are just a 9 digit number formatted as SSN.
Try one of these:
Book3.xlsx
A B C D E F 1 123-45-6789 John Doe John Doe 45-6789 John Doe 45-6789 Sheet937
Cell Formulas Range Formula D1 D1 =B1&" "&REPLACE(RIGHT(A1,6),3,0,"-") F1 F1 =B1&" "&MID(A1,4,2)&"-"&RIGHT(A1,4)
If that is what you were after, then here is another way to do it...That's the one !!!! I just switched the A1 and B1, Thank you. The REPLACE
=REPLACE(TEXT(B1,"000 00-0000"),1,3,A1)