Count number of words in a text string

[grumpyguppy]

Hi, as usual I hope to be able to get some help here. If I have a cell with a text string, how do I count the number of words contained in that string?

[canapone]

Hi,

the subject can be tricky, a first approach could be

Please Login or Register  to view this content.

Hope it's a first step

[Marc L]

Hi,

another way : L& = UBound(Split([A1].Value)) + 1 …