HOW TO COUNT CAPITAL LETTERS IN DATA?

arun sharma · Jun 26, 2009

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 · Jun 26, 2009

Hi,

Try this

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

Mike