Revealing mailto addresses

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chuck Wettish - 05 Mar 2008 05:09 GMT

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
cwettish@kenbarllc.com

Reply to this Message

Gary''s Student - 05 Mar 2008 10:36 GMT

If A1 contains:
mailto:james.ravenswood@princeton.edu

then in another cell enter:
=RIGHT(A1,LEN(A1)-7)
to display:
james.ravenswood@princeton.edu

Signature

Gary''s Student - gsnu2007e

> Hi,
>
[quoted text clipped - 10 lines]
> Chuck
> cwettish@kenbarllc.com

Reply to this Message

Henn Sarv - 05 Mar 2008 10:48 GMT

I hope You have to check something like

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

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

Henn

> Hi,
>
[quoted text clipped - 10 lines]
> Chuck
> cwettish@kenbarllc.com

Reply to this Message

Rate this thread: