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
#2
Hello @CristyLimegrover,
To count the number of characters, you can use this formula:
LEN(TRIM({Text}))
Where Text
is the column id
Thank you!
I appreciate your assistance!
1 Like
@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
1 Like
system
closed
#5
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.