Learn to properly use the Excel TEXTBEFORE and TEXTAFTER functions. There is a cool trick you can use with these functions to get the outcome you want. Check out the post for more.
Excel's TEXTSPLIT function can split words into separate cells. You can have multiple delimiters, you just have to know how to define these properly. You can also do amazing things like splitting into columns and rows and internally sorting words.
Excel recently released a set of new functions like VSTACK, TEXTSPLIT and TOCOL that will have you looking forward to working with complex files and data because your life just got more exciting (at least mine did!).