Hi,

Try this

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

Mike

"arun sharma" wrote:

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.