Hello guys,

I have a long string with different (and unique) names of people. In this string I am interested to find the position of a specific substring not by characters but by words...Let say my string has 1000 words and I am looking for the "Jeremy Wade" word position. Suppose this index is 705 (I have 704 words before).
Is it possible to find this index without any loop thru each value of this string ?
Dim myString as String
myString = "John Scott Mary Fox Terry Dyke......Jeremy Wade......"
Thank you in advance.