ExcelBanter - HOW TO COUNT CAPITAL LETTERS IN DATA?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - HOW TO COUNT CAPITAL LETTERS IN DATA? (https://www.excelbanter.com/excel-discussion-misc-queries/235084-how-count-capital-letters-data.html)

arun sharma

HOW TO COUNT CAPITAL LETTERS IN DATA?

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

HOW TO COUNT CAPITAL LETTERS IN DATA?

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.

All times are GMT +1. The time now is 02:21 AM.