Pull nth Word From Cell

Re: Find 2nd, 3rd, Or Even 10th Instance

See Formula Method:Extracting Words From Text in Excel

Custom Function Method: Get nth Word From Text[hr]*[/hr] Auto Merged Post;[dl]*[/dl]flee, try Google your Thread Title choice (Find 2nd, 3rd, Or Even 10th Instance) and see just how selfish it is! This forum is all about sharing. Those who ask questions cannot share much, but they should at least try to give back by using a helpful and search friendly Title along with a well written description of the problem.

Please do so in future, just as you agreed to in the rules when joining! Make no mistake, our rules here are enforced and are not hollow.

Re: Pull nth Word From Cell

Quote from flee01

I want to use an excel formula to find the Nth instance of a string in any string. I realize that I could right a UDF for this but find that to be a poor solution. Does anyone have any ideas?

Why ?
=flee(A1,6)

Function flee(txt As String, ref As Long) As String
Dim x
x = Split(txt)
flee = x(ref - 1)
End Function