Counting Words (Formula Column)

CristyLimegrover · November 23, 2021, 8:06pm

I was wondering if you could help me create the formula to count the characters and/or words from a text column?

For example, instead of the Formula Column reading 0 in the image, it would read 3 (words) or 23 (total characters).

Thank you so much for your help.

kolaai · November 23, 2021, 8:18pm

Hello @CristyLimegrover,
To count the number of characters, you can use this formula:

LEN(TRIM({Text}))

Where Text is the column id

CristyLimegrover · November 23, 2021, 8:37pm

Thank you! I appreciate your assistance!

JCorrell · November 23, 2021, 8:53pm

For words…

IF(LEN(TRIM({Text 1})), LEN(SUBSTITUTE(TRIM({Text 1})," ","xx")) - LEN(TRIM({Text 1})) + 1, 0)