I've been working on a formula to force the following input in data validation AB123A1234A and I used the following formula however I now learned that I need to also restrict that input to allow for only capitals but my formula isn't working correctly yet.

=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

I also just stopped testing at that point. Any help would be greatly appreciated. Thank you in advance.