Label data based on format

[smurphy2601]

I have a single list of tax IDs in a column in Excel. Some are SSN (###-##-####) and some are EIN (##-#######) based on the format. I need a formula to identify as SSN or EIN by the format the number is listed. Help.

 

[Fluff]

Hi & welcome to MrExcel.
What exactly is in the cells?

 

[smurphy2601]

Hi & welcome to MrExcel.
What exactly is in the cells?

Tax ID nubmers, both Social Security numbers (SSN) and Employee Identification numbers (EIN). SSN format is ###-##-#### and EIN format is ##-#######.

 

[Fluff]

Ok, how about

=IFERROR(CHOOSE(FIND("-",A2)-2,"EIN","SSN"),"")

 

[smurphy2601]

Ok, how about

=IFERROR(CHOOSE(FIND("-",A2)-2,"EIN","SSN"),"")

Perfect, thank you!!

 

[Fluff]

Glad to help & thanks for the feedback.