Thread: excel: count uppercase letters in a cell
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
  
Posts: 1,231
Default excel: count uppercase letters in a cell
"Harlan Grove" wrote...
"Leo Heuser" wrote...
....
=SUMPRODUCT((CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A 1))),1))=
CODE(UPPER((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1 )))))+0)
....

FWIW, you were close to getting it right. Let me help you.

=SUMPRODUCT((CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1) )),1))<
CODE(LOWER((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)) )))+0)


Reply With QuoteReply With Quote