Length of String in words vs. characters?

[Ed]

I have used Len(strVariable) to get the length of my text string in
characters. Can I also get the length in "words", or get a count of how
many words are contained in that string?

Thanks for all your help.
Ed

 

[Jonathan West]

Hi Ed,

Yes, you can, but furst you need to define what you mean by a "word". For
instance is "apple-pie" one word or two?

If you want to take the simplest case of words being separated by spaces,
then the following line of code will do the trick

numWords = UBound(Split(stringWithWords, " ")) + 1

 

[Ed]

Thanks, Jonathan. I think that's exactly what I need.

Ed