how about:

a = "11X1111111": if len(a) = 10 and mid(a,3,1) like "[A-z]" and
isnumeric(left(a,2)& right(a,7)) Then Cells(2,1) = "valid order" else
Cells(2,1) = "not valid order"

or

a = "11!1111111": Cells(2,1) = iif( len(a) = 10 and mid(a,3,1) like "[A-z]"
and isnumeric(left(a,2)& right(a,7)),"valid order" ,"not valid order")

?

;^)


"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"