Formula For Word Count In Excel. And the formula will be text is in cell a1. Here is how this formula works.
In the example shown c3 contains this formula. Sumproduct len a2 a3 len substitute a2 a3 happy len happy. Formula to count words in a particular range is len trim cell len substitute cell 1.
The above formula to count words in excel could be called perfect if not for one drawback it returns 1 for empty cells.
Here is how this formula works. Len substitute a1. Len trim b3 len substitute b3 1. Len a1 this part of the formula returns 26 which is the total number of characters in the text in cell a1.
