Barbara Excel does bring up a method that will split the text strings into several different columns. However, because the text strings don't follow a set pattern and have differing amounts of words, the email addresses will end up in different columns. Also without something reliable for the =MID() formula to look for other than the @ symbol, I turned to creating a macro to extract the email addresses quickly and easily.
Attached is a sample workbook that contains a button named "Get Emails" which is assigned to the following macro:
Hope that helps,
EDIT: We posted at the same time, rickygzz