Counting Words (Formula Column)

[CristyLimegrover]

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 (alfred)]

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

LEN(TRIM({Text}))

Where Text is the column id

[CristyLimegrover]

Thank you! I appreciate your assistance!

[JCorrell (Jim - The Monday Man)]

@CristyLimegrover

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