How do i count the number of text Entries of one word over a range

C

Chris Eaton

To explain here is an example of the columns i have:

THC will not Span
Nox will not Span
THC fails AVU
THC will not Span

I would like to be able to count how many times the phrase "THC" is
mentioned over the course of hundreds of data entry columns?

With this example i would look to have the answer of 3.

Please can anyone help.

Thanks
 
J

Jacob Skaria

If you are looking for exact match THC (in caps) then try the below formula.
Apply the formula using Ctrl+Shift+Enter instead of Enter

=COUNT(FIND("THC ",A1:A100))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to count the numbers in a Word document? 0
Function in Excel to count and list number of entries of text valuesin a row. 2
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
How do I remove the top half of a block interval? 1
Need help removing extra TOC text from number lists used as TOC levels 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0
How do I count the number of blank cells 0
Count Word in long string 2

Top