Excel 2013 - Formula to count texts with capital letters

Posted on 2016-08-10
Medium Priority
Last Modified: 2016-08-10
Dear Experts,

Could you please advise about an Excel formula, which counts how many cells are in a range with only capital letters?

In the attached example the result would be 3 (SOT,WBA,HUL)

Thanks in advance,
Question by:csehz
  • 4
LVL 35

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41751473
Assuming the strings are in the range A1:A5, then try this.....


Open in new window

LVL 35

Accepted Solution

Subodh Tiwari (Neeraj) earned 2000 total points
ID: 41751475
I think I misunderstood your question, I assumed you were trying to compare the first character of the words.

Please try this tweaked formula....


Open in new window

LVL 35

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41751478
And moreover if you want to ignore the numeric values and assuming the data is in the range A1:A6, please try this......


Author Closing Comment

ID: 41751479
Thank you very much for your regular help, it works of course
LVL 35

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41751482
You're welcome. Glad I could help this time also. :)

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Are you looking to start a business? Do you own and operate a small company? If so, here are some courses you need to take before you hire a full-time IT staff.
With the emergence of Office 365 as a superior email communication platform, many organizations have started switching over to it.  After migrating to Office 365, sometimes users, as well as organizations, will have to import PST files to Office 36…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
There may be issues when you are trying to access Outlook or send & receive emails or due to Outlook crash which leads to corrupt or damaged PST file. To eliminate the corruption from your PST file, you need to repair the corrupt Outlook PST file. U…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question