Odd and pair words

[SABIO_Soporte]

Hi there!
How can we count odd and pair words from several column in a row?

[WillowMobileSys]

SABIO_Soporte:

odd and pair words

I’ve not heard this term before. Could you explain what this means?

[SABIO_Soporte]

I need to count how many odd words are in a row.
And also need to count even words that are in a row.
odd word= two (3 letters)
even word= four (4 letters)

[Steve]

SABIO_Soporte:

I need to count how many odd words are in a row.
And also need to count even words that are in a row.

That’s not really possible.

Can you provide a better picture of what the larger goal is? Why do you want to know how many three (or four) letter words there are?

[Marc_Dillon]

This is not tested, but maybe you can try to use SPLIT(), with a space as the delimiter, then COUNT(SELECT()) with a condition of
MOD(LEN()) = 0
or
MOD(LEN()) = 1