Play with Words in Excel
Number of words in an Excel Cell
To count the number of words in a Cell, Excel did not develop a single formula. Nevertheless, you can use the combination of TRIM, LEN and SUBSTITUTE to do this.
Enter the count word formula in a cell
This is quite useful if you decide to write a lot of text in Excel.
Number of word, Counting word or line or non/empty cells