How to Get the Word Count in Excel (Using Simple Formulas)
To count the number of words, here is the formula I would use: =LEN (A1)LEN (SUBSTITUTE (A1," ",""))+1. This would return '7' as a result. Here is how this formula works: LEN (A1) – This part of the formula returns 26, which is the total number of characters in the text in cell A1. It includes the text characters as well as the space ...
![whatsapp](/images/whatsapp.png)