Posted to microsoft.public.excel.misc

Roger Govier[_3_] Roger Govier[_3_] is offline

external usenet poster

Posts: 2,480

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to extract capitalized group in text string	newbie	Excel Worksheet Functions	9	August 27th 08 07:26 PM
count characters	Rich[_2_]	Excel Discussion (Misc queries)	2	August 23rd 08 09:14 PM
CAPITALIZED ALL WORDS FROM WROKSHEET	convert all capital letter from excel	Excel Discussion (Misc queries)	2	May 1st 06 01:40 PM
Count Characters	sjs	Excel Worksheet Functions	6	December 9th 05 08:40 PM
convert capitalized text to small text (with Capitalized names an	trailboss2	Excel Discussion (Misc queries)	2	October 5th 05 10:45 PM

All times are GMT +1. The time now is 02:19 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us