extract info from an excel hyperlink
 

I have a worksheet with a column with hyperlinks that contains email
addresses. I want to import the info into outlook but the email address ends
up bejust the persons name. As an example. the hyperlink will read "Joe Blow"
and the underlying hyperlink is
I want to get the email address into my contacts list.

Thanks for your help.