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.
Courtecy:excelchamps
Music Credit: bensound.com
0