How to Count Number of Words in Excel Cell?

In this post, you will learn a quick tip on how to count the number is words in a Excel cell.

How to Count Number of Words in Excel Cell?

The following are the steps to count the number of words in excel.

  • First, prepare an excel sheet with the required details in it.
Count Number of Words in Excel
  • Now to count the number of words in an excel sheet, you will need a sentence.
  • After you type the sentence, select the box next to the sentence and then use the formula to count the number of words in excel.
  • The formula is =LEN(A1)-LEN(SUBSTITUTE(A1,” “,””))+1 (Change the name box accordingly).
Count Number of Words in Excel
  • The below picture will showcase the result from the above-mentioned steps.
Count Number of Words in Excel

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021