I want to be able to get any number of words (nth words) after a specific word. I found a formula like this online (which I can't find again and I am not sure if it was after a specific word or simply spaces) and all I had to do was change a number for the number for words I wanted to retrieve--i.e. 1 for 1, 2 for 2, and so on. I am thinking maybe it was using the substitute function.

So, to illustrate what I want, let's say I have the following in Column A

Today is a Bob wonderful day.
What day is it today Bob one Two Three
Office Supplies Testing Five Seven Bob Nine Ten Twelve Thirteen


In Column B, I want only one word after Bob, so it would have:

wonderful
one
Nine

In Column C, I want only two words after Bob, so it would have:

wonderful day.
one Two
Nine Ten

In Column D, I want only three words after Bob, so it would have:

(I am not sure what gets shown here in this case or an error, since there are only two words)
one Two Three
Nine Ten Twelve