Format SSN – Updated formula

Here 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, it will simply return the value in A4.

Enjoy,
JP

Related Articles:

• January 29, 2009 -- Excel Tutorial Series – Text Functions
• January 28, 2008 -- Counting Unique Occurrences in an Excel Spreadsheet
• September 2, 2011 -- Percentage Possible vs. Percentage of Total