Count the number of cells containing a particular word

Suppose you are asked to figure out the number of cells in a range contain a particular word, example "hi" (without double quotes).

The example is shown in the image below.


The asterik (*) is used to find matches. It substitutes any other characters.
  1. Hi* would find anything that starts with "Hi"
  2. *Hi would find anything that ends with "Hi"
  3. *Hi* would find anything that contains "Hi"
Download the workbook 
Related Posts
About Author:

Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has over 8 years of experience in data science. During his tenure, he has worked with global clients in various domains like Banking, Insurance, Telecom and Human Resource.

2 Responses to "Count the number of cells containing a particular word"

Next → ← Prev
Love this Post? Spread the Word!
Share