Count # of Capitalized Characters
Hi Matt
One way
=SUMPRODUCT((CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1) )),1))64)*
(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))<97))
--
Regards
Roger Govier
"Matt" wrote in message
...
Is there a way to count the number of capitalized characters in a text
cell?
For example, a cell value of "TTest" would return a result of 2.
Any help is greatly appreciated.
ME
|