Find / Extract Word & Words after a Specific Word

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

I was able to locate the Excel file I had the formula. It was actually finding the number of words starting from the first word / character. Also, it wasn't 1 for 1 word and 2 for 2 words, but 100 for 1 and 200 for 2 and so on. Here is the formula and hopefully it helps someone in helping me out.

Please Login or Register  to view this content.

for one word

Please Login or Register  to view this content.

for two words

I want this, but after a specific word / starting from a specific word.

In response to CAntosh (I didn't see the 2nd solution until just now and haven't tried it yet), thank you very much. On my first try I thought there was a problem, but then I realized it was due to my text having a double space, which I thought the Trim function took care of.

So, if I have the following text:

Hello Hello One Bob Three Five Seven Eight

with two spaces after the word Five

These are the results I get:

One word: Three
Two words: Three Five
Three words: Three Five
Four words: Three Five Seven (without the two spaces after Five, so I guess this is when the Trim function is being applied).

I will just remove the double spaces but will also take a look at the 2nd formula to see how it reacts in this scenario.

Once again, thanks.

In response to AlKey:

Thank you very much. Your solution doesn't have the problem I described in my previous post about double space. One thing I noticed though is that it is case sensitive--the word I am searching for in the formula must be in the same case as the word in the text.

Also, to both of CAntosh and AlKey, if you all don't mind, could you explain a bit / break down the steps as to what the formula is doing / how it works? To AlKey, what's with the triple 100's; What's happening there: REPT(" ",100)),100,100))

Isn't it just a matter of sticking another Trim right before the Substitute function like AlKey's solution? I tried doing so, but don't know if it's because this won't work or if I am sticking the parentheses in the wrong spot, but I can't get a valid formula created when I enter another Trim.