Alphanumeric Data Validation, Input Mask?

Hello,

I'm trying to do the following as a formula for data validation.

The string that should be allowed in cell A1 is:

ABCnnnnnnLLLXX

ABC is the string "ABC"
n is a number
L is a capital letter
X is either a number or a capital letter


As data validation formula, I came up with the following formula:

=AND(LEFT(A1,3)="ABC",ISNUMBER(MID(A1,4,6)+0),AND(CODE(MID(A1,10,3))>=65,CODE(MID(A1,10,3))<=90),
OR(AND(CODE(RIGHT(A1,2))>=48,CODE(RIGHT(A1,2))<=57),AND(CODE(RIGHT(A1,2))>=65,CODE(RIGHT(A1,2))<=90)),LEN($B2)=14)

My problem now is that the CODE function only looks at the first character of the selected area defined by the MID functions.

So far I can still enter strings like

ABCnnnnnnL%%X%

where % is any character

e.g. ABC123456A$*0£


Is there a function similar to the CODE function or is there an easier way of solving my problem?


Any help will be appreciated.

Kind regards
bondingfortoday