is there a word-count formula?

steven.nienaber105336
steven.nienaber105336 ✭✭✭✭✭
in Formulas and Functions

I have a cell where I need to know how many words there are.

· Share on FacebookShare on Twitter

Best Answer

  • Paul H
    Paul H ✭✭✭✭✭✭
    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)

    · Share on FacebookShare on Twitter

Answers

  • Paul H
    Paul H ✭✭✭✭✭✭
    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)

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!