HOW TO COUNT CAPITAL LETTERS IN DATA?

[arun sharma]

i hv data in which some cells are n full capital letters, some are in small
and some are proper, i want to see which cells are in upper case.

 

[Mike H]

Hi,

Try this

=SUMPRODUCT(--(EXACT(A1:A100,UPPER(A1:A100))),--(A1:A100<>""))

Mike