I would like to find a formula to idendity whether a value is formatted as an EIN ##-#######, a SSN ###-##-#### or if it is neither and needs to be corrected. The formula will go in column D. I have tried TEXT, IFs WITH ISNUMBERs and ISBLANKS, I just can not seem to get the result I am after.
Idendtify TID.xlsx
Thanks In Advance,
Chris
Last edited by chrisboughter; 02-21-2012 at 06:12 AM.
Try this UDF:
Please Login or Register to view this content.
Ben Van Johnson
Or
if you prefer formula instead VBA code.
Here the file
Cheers
Thank you so much. The formula I tried seemed so convoluted and I was in a hurry when I originally posted this. I will try both VBA and the formula and attempt to understand both. Thanks again, this is resolved
This combination of formulas did not work when the EIN, for instance, exceeded 9 digits
e.g. the result for 12-34567891 was EIN but this has 10 digits, 11 including the dash
Or the EIN had 9 digits but the dash was in the wrong place
e.g. the result for 123-456789 was EIN but the dash is in the wrong place
The VBA works perfectly, though, and seems to be the way to go.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks