I have copied a web page into EXCEL that contains numerous hyperlinks labeled
"e-mail". When I click on the hyperlink Outlook opens and the e-mail address
is populated on the "to:" line. I want copy the underlying e-mail address in
the adjacent cell, but can not find a way to do it (all I get is another cell
labeled "e-mail"). I can do it by right clicking on the cell and selecting
"edit hyperlink" and do a copy/paste w/ the e-mail address. However, I have
a ton to do and was hoping to find a quick way to copy the email address,
Thanks for your help.

Hi, John

Try =MID(A1,7,25). This says in Cell A1, keep the 7th to 25th characters.
You may have to adjust it a little, but it will work. When you are done (or
before you start), highlight the column, copy, edit, paste special, values.
That will get rid of the underlines and automatically hyperlinking to Outlook.

Hope this helps,
Carole O

"John87111" wrote:

I have copied a web page into EXCEL that contains numerous hyperlinks labeled
"e-mail". When I click on the hyperlink Outlook opens and the e-mail address
is populated on the "to:" line. I want copy the underlying e-mail address in
the adjacent cell, but can not find a way to do it (all I get is another cell
labeled "e-mail"). I can do it by right clicking on the cell and selecting
"edit hyperlink" and do a copy/paste w/ the e-mail address. However, I have
a ton to do and was hoping to find a quick way to copy the email address,
Thanks for your help.

Carole, thanks for the answer, but unfortunately that did not do what I want.
The cell (c4) reads "E-mail" & when the cursor is pointed at the label the
underlying hyper link is displayed (eg. ). I want to
get the underlying email address in the cell next to C4 (i.e. E4 would read
). Can you (or others!) offer any help

Thanks!!

"Carole O" wrote:

Hi, John

Try =MID(A1,7,25). This says in Cell A1, keep the 7th to 25th characters.
You may have to adjust it a little, but it will work. When you are done (or
before you start), highlight the column, copy, edit, paste special, values.
That will get rid of the underlines and automatically hyperlinking to Outlook.

Hope this helps,
Carole O

"John87111" wrote:

I have copied a web page into EXCEL that contains numerous hyperlinks labeled
"e-mail". When I click on the hyperlink Outlook opens and the e-mail address
is populated on the "to:" line. I want copy the underlying e-mail address in
the adjacent cell, but can not find a way to do it (all I get is another cell
labeled "e-mail"). I can do it by right clicking on the cell and selecting
"edit hyperlink" and do a copy/paste w/ the e-mail address. However, I have
a ton to do and was hoping to find a quick way to copy the email address,
Thanks for your help.

Dave Peterson posted a solution to a similar question in the following
thread:


http://groups.google.ca/groups?&thre...apeXSPAM. com

John87111 wrote:
Carole, thanks for the answer, but unfortunately that did not do what I want.
The cell (c4) reads "E-mail" & when the cursor is pointed at the label the
underlying hyper link is displayed (eg. ). I want to
get the underlying email address in the cell next to C4 (i.e. E4 would read
). Can you (or others!) offer any help

Thanks!!

"Carole O" wrote:


Hi, John

Try =MID(A1,7,25). This says in Cell A1, keep the 7th to 25th characters.
You may have to adjust it a little, but it will work. When you are done (or
before you start), highlight the column, copy, edit, paste special, values.
That will get rid of the underlines and automatically hyperlinking to Outlook.

Hope this helps,
Carole O

"John87111" wrote:


I have copied a web page into EXCEL that contains numerous hyperlinks labeled
"e-mail". When I click on the hyperlink Outlook opens and the e-mail address
is populated on the "to:" line. I want copy the underlying e-mail address in
the adjacent cell, but can not find a way to do it (all I get is another cell
labeled "e-mail"). I can do it by right clicking on the cell and selecting
"edit hyperlink" and do a copy/paste w/ the e-mail address. However, I have
a ton to do and was hoping to find a quick way to copy the email address,
Thanks for your help.






--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

And if the =geturl() function returns , you could use:

=mid(geturl(a1),8,255)

It just ignores the first 7 characters.

Debra Dalgleish wrote:

Dave Peterson posted a solution to a similar question in the following
thread:


http://groups.google.ca/groups?&thre...apeXSPAM. com

John87111 wrote:
Carole, thanks for the answer, but unfortunately that did not do what I want.
The cell (c4) reads "E-mail" & when the cursor is pointed at the label the
underlying hyper link is displayed (eg. ). I want to
get the underlying email address in the cell next to C4 (i.e. E4 would read
). Can you (or others!) offer any help

Thanks!!

"Carole O" wrote:


Hi, John

Try =MID(A1,7,25). This says in Cell A1, keep the 7th to 25th characters.
You may have to adjust it a little, but it will work. When you are done (or
before you start), highlight the column, copy, edit, paste special, values.
That will get rid of the underlines and automatically hyperlinking to Outlook.

Hope this helps,
Carole O

"John87111" wrote:


I have copied a web page into EXCEL that contains numerous hyperlinks labeled
"e-mail". When I click on the hyperlink Outlook opens and the e-mail address
is populated on the "to:" line. I want copy the underlying e-mail address in
the adjacent cell, but can not find a way to do it (all I get is another cell
labeled "e-mail"). I can do it by right clicking on the cell and selecting
"edit hyperlink" and do a copy/paste w/ the e-mail address. However, I have
a ton to do and was hoping to find a quick way to copy the email address,
Thanks for your help.





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

--

Dave Peterson