is there a word-count formula?
I have a cell where I need to know how many words there are.
Best Answer
-
Check the length of the sting, remove all the spaces, check again, the difference + 1 is the word count.
=IF(text@row <> "", LEN(text@row) - LEN(SUBSTITUTE(text@row, " ", "")) + 1, 0)
Answers
-
Check the length of the sting, remove all the spaces, check again, the difference + 1 is the word count.
=IF(text@row <> "", LEN(text@row) - LEN(SUBSTITUTE(text@row, " ", "")) + 1, 0)
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!