Revealing mailto addresses

[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)

 

[Gary''s Student]

If A1 contains:
mailto:[email protected]

then in another cell enter:
=RIGHT(A1,LEN(A1)-7)
to display:
(e-mail address removed)

 

[Henn Sarv]

I hope You have to check something like

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

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

Henn