Hi when I was checking my data validation formula I found it failed terribly.
The format I'm trying to obtain is: AA##AA####A
A is alpha a-z and does not need to be case sensitive
# is numeric 0-9
the formula I was using =AND(ISTEXT(LEFT(D1,2)),ISNUMBER(MID(D1,3,2)*1),ISTEXT(MID(D1,5,2)),ISNUMBER(MID(D1,7,4)*1),ISTEXT(LEFT(D1,11,1)),LEN(D1)=11)
it failed when I tried the following
<colgroup><col width="113" style="mso-width-source:userset;mso-width-alt:4132;width:85pt"> </colgroup><tbody>
</tbody>
I also just stopped testing at that point. Any help would be greatly appreciated. Thank you in advance.
The format I'm trying to obtain is: AA##AA####A
A is alpha a-z and does not need to be case sensitive
# is numeric 0-9
the formula I was using =AND(ISTEXT(LEFT(D1,2)),ISNUMBER(MID(D1,3,2)*1),ISTEXT(MID(D1,5,2)),ISNUMBER(MID(D1,7,4)*1),ISTEXT(LEFT(D1,11,1)),LEN(D1)=11)
it failed when I tried the following
| aa123a1234a |
| aa12341234a |
| aa12aa12345 |
| 1a12aa1234a |
<colgroup><col width="113" style="mso-width-source:userset;mso-width-alt:4132;width:85pt"> </colgroup><tbody>
</tbody>
I also just stopped testing at that point. Any help would be greatly appreciated. Thank you in advance.
