Thread: excel: count uppercase letters in a cell
View Single Post
  #2   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
"harry bachrach" <harry wrote...
excel: how to count uppercase letters in a cell

One way,

=SUMPRODUCT(LEN(A1)-LEN(SUBSTITUTE(A1,{"A";"B";"C";"D";"E";"F";
"G";"H";"I";"J";"K";"L";"M";"N";"O";"P";"Q";"R";"S ";"T";"U";"V";
"W";"X";"Y";"Z"},"")))


Reply With QuoteReply With Quote