I need to evaluate the values in Column A and return a "1" if valid, "0" if invalid. I have tried using the =IF(IFERROR(SEARCH formula to evaluate but am not having luck. Examples of valid values are in cell A1, A3, and A4 below. Examples of invalid values are in A2, and A5. How can I write a single formula to perform this evaluation for these different numeric strings? Thanks in advance.
Column A
100101
001317072-001317072
224-159-1233
2241591233-250001103659
10UTCC-10UTCC
Bookmarks