Formulas for Counting the Number of Words in a Cell or Range in Excel!!

Excel Formulas for Counting the Number of Words in a Cell or Range:

In this article, we will guide you to learn the simple and easy Formulas for Counting the Number of Words in a Cell or Range in Excel Office 365. Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Formula Syntax:

• The below formula will help to find the number of words in a cell or range.

{=SUM(IF(LEN(TRIM(A2:A6))=0,0,LEN(TRIM(A2:A6)0-LEN(SUBSTITUTE(A2:A6,” “,””))+1))}

Example:

• In the below screenshot, the input ranges are given in Column A.
• Then, enter the given formula in the formula bar.
• After applying the formula, we will get the result in Cell B2 as shown below.

Explanations for Syntax:

• SUM – This function is used to add the values from a cell. Read more on the SUM Function.
• IF – In Excel, the main purpose of this function is to return one value for a TRUE result and another one for a FALSE result. For more details on IF Function.
• *LEN * – It will return the length of a text string as the number as a character. Read more of the LEN Function.
• *TRIM * – The TRIM Function helps to remove the extra spaces from the text and no space at the start or end of the text string.
• SUBSTITUTE – The Excel SUBSTITUTE Function can replace the existing text with the new text string from a text string.

Bottom Line:

From this article, you can know the formula to count the number of words in a cell or range in Excel Office 365. Leave your feedback in the comment box. Thank you so much for Visiting Our Site!! Continue learning on Geek Excel!!