Formula For Word Count In Excel. The above formula to count words in excel could be called perfect if not for one drawback it returns 1 for empty cells. Substitute a1 this part of the formula removes all the spaces from the text.
To count the total words in a cell you can use a formula based on the len and substitute functions. And the formula will be text is in cell a1. Len a1 len substitute a1 1.
So the result in this case.
In the generic version of the formula rng represents the range to check and txt is the word or substring to count. Len substitute a1. So the result in this case. Popular course in this category.
