Delete all spaces on text to count words

Platform discussions
,
1

Hello,

I search to count word on text column with formula to multiply with a price after.

I can count characters with LEN but I can’t count word.

I have an idea with
Use LEN + TRIM + SUBSTITUTE

But I need to delete all space on my text.
And the formula
SUBSTITUTE({text},” “,””) doesn’t work, spaces are still on the text.

Do you have a solution ?

2

@KevinR,

The SUBSTITUTE() function in monday does not allow substitution of null strings, as you discovered.

This formula will give you the word count:

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

Jim - Subscribe to The Monday Man
Watch Our Latest Video: HELP!!

3

Many thanks for your reply, it’s work thanks

4

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