Excel Formulas to Count Total Words in a Cell ~ Easy Guide!!

Sometimes you need to find out how many number of words present in the cell. If you identify and count them one by one, it will waste a lot of time. So here we are going to see the simple methods to count the total number of words present in a cell in Excel. 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

Generic Formula:

Use the below formula to find out the total number of words in a cell.

*=LEN(TRIM(A1))-LEN(SUBSTITUTE(A1,” “,””))+1 *

Syntax Explanations:

TRIM – This function helps to remove the extra spaces from the text and there is no space at the start or end of the text string. Read more on the TRIM function.

LEN – In Excel, the LEN function is used to find the length of the text string.

SUBSTITUTE – This function helps to replace existing text with new text in a text string when you want to replace text based on its content, not position. Read more on the SUBSTITUTE function.

A1 – It represents the input value.

Comma symbol (,) – It is a separator that helps to separate a list of values.

Parenthesis () – The main purpose of this symbol is to group the elements.

Minus Operator (-) – This symbol will help to subtract any two values.

Plus operator (+) – This symbol is used to add the values.

Practical Example:

Refer to the below example image.

First, we will enter the input text strings in Column B.

Now we need to find out the total number of words in a cell.

Select any cell and type the above-given formula.

Finally, press the ** ENTER** key, you can get the result as shown below.

Wind-Up:

From this chapter, you can get some clarification on how to count the total number of words in a cell in Excel. Leave a comment or reply below to let me know what you think!

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **

Read Ahead:

Excel Formulas to Count specific word in a range ~ Easy Tutorial!!

Formulas for Counting the Dates from a given Year in Excel!!

Formulas for Counting Non-Contiguous Range in Excel Using COUNTIF!!

Excel Formulas to Count Line Breaks in A Cell ~ A Complete Guide!!