Count Capital Letter

Topic

New Reply

Is there a way to count the number of capitalized characters in a text cell?
For example, a cell value of “TTest” would return a result of 2.

TIA

Reply | Quote

Replies

For cell A1:

=SUMPRODUCT((CODE(MID(A1,ROW(INDIRECT(“1:”&LEN(A1))),1))>64)*(CODE(MID(A1,ROW(INDIRECT(“1:”&LEN(A1))),1))<91))

This only counts letters A…Z, not letters with accents such as É.

Reply | Quote

For cell A1:

=SUMPRODUCT((CODE(MID(A1,ROW(INDIRECT(“1:”&LEN(A1))),1))>64)*(CODE(MID(A1,ROW(INDIRECT(“1:”&LEN(A1))),1))<91))

This only counts letters A…Z, not letters with accents such as É.

Hans

Thanks.
I am always lost when it come to text and together with mega-formula

Reply | Quote