You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Dan" wrote in message
...
Perfect! Thank you very much.
--
Dan


"T. Valko" wrote:

Code() doesn't really need Left().

Yeah, that'll save a few keystrokes.

=AND(LEN(A1)=6,CODE(A1)=65,CODE(A1)<=90,COUNT(-MID(A1,ROW(INDIRECT("2:6")),1))=5)

can't get your formula to accept: A12345

If you're testing it as a worksheet formula it has to be array entered.

--
Biff
Microsoft Excel MVP


"RagDyer" wrote in message
...
Code() doesn't really need Left().

Besides, can't get your formula to accept:
A12345
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit
!
---------------------------------------------------------------------------
"T. Valko" wrote in message
...
This works based on the following conditions:

Length must be 6 characters
The 1st character must be upper case A-Z
Chars 2 through 6 must be numbers 0-9

=AND(LEN(A1)=6,CODE(LEFT(A1))=65,CODE(LEFT(A1))<= 90,COUNT(-MID(A1,ROW(INDIRECT("2:6")),1))=5)

--
Biff
Microsoft Excel MVP


"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