excel: count uppercase letters in a cell
The brute force approach I showed is at least easily adapted to
include any letters one would care to check.
Here is another method to count the upper case letters that should also be
easily adaptable to include any set of characters one would want to count...
=SUMPRODUCT(1*(NOT(ISERR(FIND(MID(A1,ROW(INDIRECT( "1:"&LEN(A1))),1),"ABCDEFGHIJKLMNOPQRSTUVWXYZ",1)) )))
Rick
|