How do I count phrases in a list?

I am trying to count the number of key phrases in a list (text field). I found help on Split Text to Columns on how to count words, but am wondering if I can adapt the formula in such a way that counts phrases instead? Here are some screenshots! In the first image I would like record 1 to have a word count of 2 rather than 4. The second image shows the current word count formula.

Screen Shot 2022-05-19 at 10.51.07 AM
Screen Shot 2022-05-19 at 10.51.20 AM

Hi Jo. The SUBSTITUTE should be changed to sub out the comma instead of white space.

IF(Words, LEN(Words) - LEN(SUBSTITUTE(Words, ',', ''))+1, 0)

I think that will do what you want.
3 Likes

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