Alpha numeric excel data validation with UPPER

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.

Numbers in a text string are evaluated as text, so ISTEXT is no good here. As you can't use arrays in validation, you have to check each of the letters individually.

=AND(LEN(D1)=11,EXACT(D1,UPPER(D1)),ISNUMBER(--MID(D1,3,3)),ISNUMBER(--MID(D1,7,4)),ISERROR(--MID(D1,1,1)),ISERROR(--MID(D1,2,1)),ISERROR(--MID(D1,6,1)),ISERROR(--MID(D1,11,1)))

Long formula, but probably the simplest way to do it.