A bit late, but look at the extended text functions here
These functions allow you to specify various delimiters for splitting text.
You can enter negative values so that you can get the text from the last space to the end. =xtndRight(A1, " ",-1)
In the extended mid formula =xtndmid(A1, ".",1," ",-1) for example,
you can use two different delimiters and each can be counted from the start or the end of your text.
So just drop all your text into Excel and use these functions to get the bits you want into a series of cells.
Delimiters can be any length, so once you get one word with one function you can use that word as the delimiter for the next function.