Maybe there is a simpler way, but this example springs to mind:

a="1A1":? a like "[0-9][A-Z][0-9]"

a="1a1":? a like "[0-9][a-zA-Z][0-9]"

a="1a1":? ucase(a) like "[0-9][A-Z][0-9]"

(try 'em as-is in Immediate window)

"antinoz" wrote in message
...
I'm trying to validate data in a column of cells to check that the format
is
"NNANNNNNN" (N= number A= Alpha I have) all the cell contents are
different
but have 9 characters containing the alphanumeric format as shown

I want to put it in an If statement:

so if cell A1 = mask "NNANNNNNNN" cell A2 = "Valid order"