How to count words in MS Excel

In Excel, there is no specific function to count words.You can count characters with LEN but not words.

But, you can use the following formula which can help you to count words from a cell.=LEN(B3)-LEN(SUBSTITUTE(B3,” “,””))+1This formula counts the number of spaces from a cell and adds 1 to it after that which equals the total number of words in a cell.

#HappyLearning!

Courtecy:excelchamps

Music Credit: bensound.com