|
Junior Member
|
|
Location: Ireland
Posts: 29
|
|
Quote:
Originally Posted by Peo Sjoblom[_2_]
=AND(LEN(A1)=8,ISNUMBER(--(LEFT(A1,7))),CODE(RIGHT(A1,1))=65,CODE(RIGHT(A1, 1))<=90)
the above will not allow lower case at the end, if you want that the users
to be able to enter both a and A use
=AND(LEN(A1)=8,ISNUMBER(--(LEFT(A1,7))),CODE(UPPER(RIGHT(A1,1)))=65,CODE(UP PER(RIGHT(A1,1)))<=90)
--
Regards,
Peo Sjoblom
"dalymjl" wrote in message
...
dan dungan;716380 Wrote:
try placing the following formula in the "formula" section of the data
validation dialog box.
=AND(LEN(A1)=8,NOT(ISNUMBER(VALUE(RIGHT(A1,1)))))
Many thanks for you help. There is still a slight problem as that
validation would permit a letter or other character in the first 7
digits and I only want numbers in the first 7 places.
regards
MJD
--
dalymjl
|
Many thanks Peo.
That works brilliantly!
|