Uppercase question

Posted by Andonny on June 21, 2001 2:56 AM

Hi,
I am trying to display in B1 "This is uppercase" if all characters in Cell A1 are uppercase. Also there could be numbers, ? or % mixed in but it still should tell me that it is uppercase. If any of the letters are lowercase it should leave an empty cell. These are some of the examples which could be in cell A1.
10% DISCOUNT ==> This is uppercase
Mr.Lang ==>
MR. THOMAS ==> This is uppercase

Thank you very much for your kind help
Andonny

Posted by Aladin Akyurek on June 21, 2001 4:22 AM

Hi Andonny,

It seems you often come up with something that "requires" another array-formula:

=IF(ISNUMBER(MATCH(ROW($97:$122),CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),0)),"","This is uppercase")

Aladin

PS. Don't forget the answering the e-mail. :)

===============

Posted by Andonny on June 21, 2001 4:48 AM

Hi Aladin,
It seems that way but I am always confronted with new problems and they are never easy for me to solve. Thats why I appreciate your help a lot.

Take care and thank you very much
Andonny

Posted by Andonny on June 21, 2001 4:55 AM

Re: ROW($97:$122)

Hi,
I am not sure what ROW($97:$122) means. Would you be so kind and explain it for me.

Thank you
Andonny

Posted by Aladin Akyurek on June 21, 2001 5:02 AM

Re: ROW($97:$122)

It generates an array of numeric values that exactly match the ASCII values of the lowercase letters a..z.

Aladin

=========