Data validation for Capital Letter

[gilbert]

Is there anyway, to validate a cell that Capital letter is key in? That
is to say, if a small letter is keyed in, it will stop the users even
the right word is key in.

I am using the following in my validation :-

=AND(LEN(A10)=5,LEFT(A10,1)="P")

ie. to restrict that A10 is key in with some thing that begins with P
but it will not stop us from keying in a small letter P.

Please advise.

 

[Peo Sjoblom]

Try


=AND(LEN(A10)=5,EXACT(LEFT(A10),"P"))

 

[Pete]

Code for Big "P" is 80

try

=AND(LEN(A10)=5,CODE(A10)=80)