Count the Times a Word Appears in a Cell or a Range in Excel Office 365!!
Tags: countthetimesawordap, kutoolsexceltutorial, kutools
Published: 2020-10-03 12:07:05

---
title: Count the Times a Word Appears in a Cell or a Range in Excel Office 365!!
published: true
date: 2020-10-03 08:24:16 UTC
tags: CounttheTimesaWordAp,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/count-the-times-a-word-appears-in-a-cell-or-a-range-in-excel-office-365/
---

In this guide, we are going to explore how to **Count the Times a Word Appears in a Cell or a Range in Excel Office 365** using **Kutools**. Let’s get into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Count the Times a Word Appears in a Single Cell:

To count the times a word appears in a single cell in Excel, do as follows.

- Let’s consider the below example, and we are going to count how many times a specific word appears in a **cell B2**. Do as follows.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-5.png)<figcaption id="caption-attachment-15037">Example</figcaption>

-  You need to select a blank cell to display the result, then on the **Kutools Tab, select** the **Formula Helper** option, **choose** the **Formula Helper**  option from the menu.

![Select Formula Helper option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-Formula-Helper-option.png)<figcaption id="caption-attachment-14911">Select Formula Helper option</figcaption>

- It will open the **Formula Helper dialog box. **
- You need to **select** the **Count the number of a word**  option under the **Choose a Formula** section.
- You can also **check** the **Filter** box and **enter the word count** into the text box to filter the formula quickly.
- In the **Text box,** you need to **select a cell** in which you want to count the number of a specific word using the browse button.
- In the **Word box,** you need to **select the cell containing the word** or directly enter the word that you want to count.
- Next, hit the **OK** button.

![Formula Helper dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Formula-Helper-dialog-box-2.png)<figcaption id="caption-attachment-15038">Formula Helper dialog box</figcaption>

- Now, the result is displayed in the selected cell as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-3.png)<figcaption id="caption-attachment-15039">Output</figcaption>

### Note:

- You can also count the times a word appears in each cell in the list by applying the **Count the number of a word ** in the first cell.
- Then, you need to drag the cell down to fill the remaining cells.

## Steps to Count the Times a Word Appears in a Range:

Here, we come up with the set of instructions to count the times a word appears in a range. Kindly, follow the below instructions.

- In the below example, and we are going to count how many times a specific word appears in a range B3:B5. Do as follows.

![Example text strings](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/1-3.png)<figcaption id="caption-attachment-15040">Example text strings</figcaption>

- You need to select a blank cell to display the result, then on the **Kutools Tab, select** the **Formula Helper** option, **choose** the **Formula Helper**  option from the menu.

![Select Formula Helper option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-Formula-Helper-option.png)<figcaption id="caption-attachment-14911">Select Formula Helper option</figcaption>

- It will open the **Formula Helper dialog box. **
- You need to **select** the **Count the number of a word**  option under the **Choose a Formula** section.
- You can also **check** the **Filter** box and **enter the word count** into the text box to filter the formula quickly.
- **Text box –** you need to **select a range** in which you want to count the number of a specific word.
- **Word box –** you need to **select the cell containing the word** or directly enter the word that you want to count.
- Next, hit the **OK** button.

![Formula Helper dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/2-3.png)<figcaption id="caption-attachment-15041">Formula Helper dialog box</figcaption>

- Now, the result is displayed in the selected cell as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/3-3.png)<figcaption id="caption-attachment-15042">Result</figcaption>

### Note:

- This feature supports the undo option ( **CTRL + Z** ).

## Bottom-Line:

In this guide, you can clearly understand the steps to **Count the Times a Word Appears in a Cell or a Range in Excel Office 365** using **Kutools** with example images. Give your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### See Also:

- [How to Find the Largest Value Smaller than a Specified Number in Excel?](https://geekexcel.com/how-to-find-the-largest-value-smaller-than-a-specified-number-in-excel/)
- [How to Extract Substring Between Two Texts in Excel?](https://geekexcel.com/how-to-extract-substring-between-two-texts-in-excel/)