Alphanumeric limitation
ISNUMBER(--RIGHT(A1,5))
That will accept the following:
A1 = X1.234
A1 = X-1234
A1 = X123E1
--
Biff
Microsoft Excel MVP
"RagDyer" wrote in message
...
This works for alpha being upper case *only*:
=AND(LEN(A1)=6,ISNUMBER(--RIGHT(A1,5)),CODE(A1)=65,CODE(A1)<=90)
To accept upper *or* lower case alpha:
=AND(LEN(A1)=6,ISNUMBER(--RIGHT(A1,5)),
OR(AND(CODE(A1)=65,CODE(A1)<=90),AND(CODE(A1)=97 ,CODE(A1)<=122)))
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Dan" wrote in message
...
Looking for help to validate a single cell to an alphanumeric entry that
is
exacly 6 characters in length with the first character required to be a
letter and the remaining characters to be numbers. Exp: A00142 orT10001,
ect.
--
Dan
|