View Single Post
  #1   Report Post  
Old January 7th 05, 10:03 PM
pat_rick
 
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