Dereferencing hyperlinks

  • Thread starter Thread starter Usenet User
  • Start date Start date
U

Usenet User

I have a spreadsheet with a column FILLED with names. Each name has
an attached mailto: hyperlink that contains the email address of the
person named.

I am trying to create two new columns - one with the person's name
only, and the second with their email address only. I can not find a
method of copying ONLY the hyperlink to a new cell.

Can this be done?

Thanks!

Please cc responses to usenetq at yahoo dot com
 
Back
Top