Thread: excel: count uppercase letters in a cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default excel: count uppercase letters in a cell
Another one:

=SUMPRODUCT(LEN(A1)-LEN(SUBSTITUTE(A1,CHAR(ROW(INDIRECT("65:90"))),"") ))

--
Biff
Microsoft Excel MVP


"harry bachrach" <harry wrote in message
...
excel: how to count uppercase letters in a cell


Reply With QuoteReply With Quote