How To Extract Email Addresses That Are Embedded

I received an Excel spreadsheet that has contact info (name, address, phone, email, etc) but the email isn't visable unless I hover over their first name (a link) and I can see it in there. If I click the first name link, it opens a new Outlook email message. (Cool, but not what I need...)

When I copied the whole spreadsheet and pasted it as a tab into an existing Excel document of my own, the email addresses are no longer there, it now shows the path to where my original document is stored. Where did the email part go? how do I extract the emails out? Ideally I'd like to put them in a new column next to their name...sorted in my original document or in the tab...either one.