Hyperlink info & help needed
 

I have copied a web page into EXCEL that contains numerous hyperlinks labeled
"e-mail". When I click on the hyperlink Outlook opens and the e-mail address
is populated on the "to:" line. I want copy the underlying e-mail address in
the adjacent cell, but can not find a way to do it (all I get is another cell
labeled "e-mail"). I can do it by right clicking on the cell and selecting
"edit hyperlink" and do a copy/paste w/ the e-mail address. However, I have
a ton to do and was hoping to find a quick way to copy the email address,
As an example, The cell (c4) reads "E-mail" & when the cursor is pointed at
the label the underlying hyper link is displayed (eg.
). I want to get the underlying email address in the
cell next to C4 (i.e. E4 would read ). All help is
appreciated

Thanks!!