I want to count the number of words in an input so my user knows how many words have been written. Is there a no code formula for that? I know there is a no code formula to count the number of characters. But what about words? 
You could split your string by space character, then count the number of items you get!
1 Like
That worked! Is there a way to limit the number of words being shown? Example, I only want the first 100 words to show.
Currently, I can limit to show the first 500 characters by using the subtext(input, 0 , 500) formula. Is there a way to do so for the first 100 words (instead of characters), for example?
You can still use the split method, then pick only the 100 first item and join them again
