Revealing mailto addresses

  • Thread starter Thread starter Chuck Wettish
  • Start date Start date
C

Chuck Wettish

Hi,

I have a list of names from a website. The html has each person's name as a
mailto hyperlink. When I paste this list into excel the mailto formatted
names remain. I can view the email address in each link but I am looking for
a way to extract the address from the names and put them in their own
column.

Any ideas?

Thanks

Chuck
(e-mail address removed)
 
I hope You have to check something like

=LEFT(A1;FIND("@";A1)-1)

this gives You the "name" part of e-mail address

Henn
 
Back
Top