Count Capital Alphabet in Range

0 views
Skip to first unread message

Vibhuti Shrotriya

unread,
Oct 12, 2015, 7:26:39 AM10/12/15
to Excel VBA Lab
Dear All,

I want to count Capital Alphabet in Range

Example :

London
indiA
Lanka
nepaL

Answer is 4

Is it possible.

Kindly help.


Thanks
Vibhuti

Ashish Kumar

unread,
Oct 12, 2015, 10:37:47 PM10/12/15
to Excel...@googlegroups.com
Dear Vibhuti,

Check this...!




Note : Please visit on forum page for download the sheet


Regards
Ashish Kumar
Count Alphab.xlsx

Vibhuti Shrotriya

unread,
Oct 13, 2015, 6:12:29 AM10/13/15
to Excel VBA Lab
Dear Ashish,

Working perfect for me...! Great Work.


Thanks
Vibhuti

Ashu K

unread,
Oct 14, 2015, 8:36:54 AM10/14/15
to Excel VBA Lab
Dear Sir,

Superb Solution.



Thanks & Regards
Ashu Kenith
Reply all
Reply to author
Forward
0 new messages