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

You have to evaluate each characters in your formula

Just confirm you are looking data validation for this

ABCnnnnnnLLLXX

Or

ABCnnnnnnL%%X%