If we know that no text will be longer than 256 characters...
Then maybe this?:
=INDEX(FREQUENCY(CODE(MID(A1,COLUMN($1:$65536),1)& "~"),{64,91}),2)
***********
Regards,
Ron
XL2002, WinXP
"T. Valko" wrote:
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