case sensitive & set amount of characters

J

JINXY

is there a fomula i can use that would make a cell case sensitive and would only allow a certain number of characters
please help
 
P

Peo Sjoblom

You can use data>validation, allow>custom

=AND(LEN(A1)<=5,EXACT(A1,UPPER(A1)))

if you select A and do the above and use the above formula it will allow max
5 characters and they all have to be upper case

--

Regards,

Peo Sjoblom


JINXY said:
is there a fomula i can use that would make a cell case sensitive and
Click to expand...
would only allow a certain number of characters
 
Top