How would you write VBA code that would search a cell (containing words and numbers) for a particular word, pull that word out of the cell and place it into the next column over?

Example:

Cell contains the string "Happy New Year 2008 Be safe and have fun 03010"

How would I pull out the word "Year" and put it into the next column and leave everything else in the cell?

Thanks!