View Single Post
  #1   Report Post  
Old January 7th 05, 09:03 PM
Posts: n/a
Default How can I extract hyperlink value

I copied a table from web site to excel ehich has the email address as
hyperlink to names of people. In Excel it appears as hyperlink and shoes the
name, and email address as hyperlink value.
How can I extract the hyperlink value and have the acctual email address on
another cell.

Thanks in advance