I just did it. Follow these steps

1) Copy email addresses from an e-mail
2) Paste in a single cell into excel
3) Highlight cell and use in excel menu Data - text to columns
4) Select delimited.  Use only semicolon
5) Copy cells in row and Paste special with transpose.
6) You now have email names with commas (seperating first and last names)
and dashes (Optional if multiple company sites).  Highlight all email
addresses in one column.  Again use text to columns.  This time use delimited
with commas and dashes as seperators.

You will now have names wirth first and last names in different columns.