Jack,
For cell A1, use Data / Validation, Allow - Custom, and in the formula
area, enter (take out any extra line returns before using this):
=OR(A1="BR",A1="NT",AND(NOT(ISERROR(FIND(RIGHT(A1, 1),"LPTVY"))),NOT(ISERROR(
VALUE(LEFT(A1,LEN(A1)-1))))),AND(NOT(ISERROR(FIND(LEFT(A1,1),"KD"))),NOT (ISE
RROR(VALUE(RIGHT(A1,LEN(A1)-1))))))
HTH,
Bernie
MS Excel MVP
"Jack Sheet" wrote in message
...
Hi all
I want to set data validation on a cell so that it will accept the
following
(and only the following) text strings:
(1) "BR" (literally)
or
(2) "NT" (literally)
or
(3) "nA" where n is any positive integral numerical value including zero
and
A may take any of the values "L", "P", "T", "V" or "Y"
or
(4) "An" where n is any positive integral numerical value including zero
and
A may take either of the values "K" or "D".
Is this possible, please, and if so how? thanks
--
Return email address is not as DEEP as it appears
|