(I thought I'd responded to Harry's post....oh, well....it's late)

***********
Regards,
Ron

XL2002, WinXP


"Ron Coderre" wrote:

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