Format SSN - Updated formula
Wednesday, February 20th, 2008 43 viewsHere is an update to the code I have posted on the site at Format SSN I realized that the last part of the formula doesn't check for dashes. Here is the updated formula: =IF(AND(LEN(A4)>6, LEN(A4)9, NOT(ISERROR(FIND("-",A4)))),A4,LEFT(A4,3)&"-"&MID(A4,4,2)&"-"&RIGHT(A4,4))) Notice the addition of NOT(ISERROR(FIND("-",A4))) in the second IF formula. If the formula already has dashes in it, ...
