How can we count odd and pair words from several column in a row?
I’ve not heard this term before. Could you explain what this means?
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)
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?
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
MOD(LEN()) = 1