Counting Words (Formula Column)

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.

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


Where Text is the column id

Thank you! :pray: I appreciate your assistance!

1 Like


For words…

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

Jim - Subscribe to The Monday Man
Watch Our Latest Video: Get Rid of Subitems

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.