case sensitive & set amount of characters

[Guest]

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

 

[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

is there a fomula i can use that would make a cell case sensitive and

would only allow a certain number of characters

 

[Guest]

Perfect

Thank you