Count the Number of Words in a Cell or a Range in Excel Office 365!!
Tags: countthenumberofword, kutoolsexceltutorial, kutools
Published: 2020-09-18 10:37:36

---
title: Count the Number of Words in a Cell or a Range in Excel Office 365!!
published: true
date: 2020-09-18 05:06:27 UTC
tags: CounttheNumberofWord,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/count-the-number-of-words-in-a-cell-or-a-range-in-excel-office-365/
---

## Count the Number of Words in a Cell or a Range in Excel:

In this article, we are going to see how to Count the Number of Words 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 Number of Words in a Cell:

To count the number of words in a cell in Excel, do as follows.

- If you have a cell-like the below screenshot shown and you want to count the number of words in that cell, then do the following steps.

![Example Text String](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-66.png)<figcaption id="caption-attachment-14154">Example Text String</figcaption>

- You have to **select** a **blank**  **cell** to display the result, then on the **Kutools** tab, **select** the **Formula**  **Helper** option under the **Formula** section, and **choose**  **Formula**  **Helper** from the drop-down menu.

![Choose Formula Helper Option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-61.png)<figcaption id="caption-attachment-14155">Choose Formula Helper Option</figcaption>

- It will open the **Formula**  **Helper**  **dialog**  **box**.
- In that dialog box, **select** the **Count**  **total**  **words** option from **Choose**  **a**  **Formula** box.
- You can **check** the **filter** box and **enter**   **count** into the text box to filter the formula quickly.
-  In the **range** box, click the button to **select the input range** where you want to count the total words.
- Then, hit the **OK** button.

![Formula Helper Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/3-25.png)<figcaption id="caption-attachment-14156">Formula Helper Dialog Box</figcaption>

- Now, you can be able to see the result in the selected cell, and the corresponding formula is created automatically in the formula bar.

![Total Count of words in a cell](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/4-11.png)<figcaption id="caption-attachment-14157">Total Count of words in a cell</figcaption>

## Count the Number of Words in a Range:

To count the number of words in a range, kindly, follow the below instructions.

- If you want to count the total number of words in a range, do as below steps.

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

- You have to **select** a **blank**  **cell** to place the result, then on the **Kutools** tab, **select** the **Formula**  **Helper** option under the **formula** section, and **choose**  **Formula**  **Helper** from the drop-down menu.

![Choose Formula Helper Option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/6-4.png)<figcaption id="caption-attachment-14161">Choose Formula Helper Option</figcaption>

- It will open the **Formula**  **Helper**  **dialog**  **box**.
- In that dialog box, **select** the **Count**  **total**  **words** option from **Choose**  **a**  **Formula** box.
- You can **check** the **filter** box and **enter**   **count** into the text box to filter the formula quickly.
-  In the **range** box, click the button to **select the input range** where you want to count the total words.
- Then, hit the **OK** button.

![Formula Helper Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/7-3.png)<figcaption id="caption-attachment-14162">Formula Helper Dialog Box</figcaption>

- You can get the result as shown in the below screenshot.

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

## Closure:

From the above article, you can clearly learn the steps to **Count the Number of Words in a Cell or a Range in Excel Office 365** using **Kutools**. Leave your **suggestions** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!