Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy subtotal information to new sheet | Excel Worksheet Functions | |||
How do I copy the underlying e-mail hyperlink information from a . | Excel Discussion (Misc queries) | |||
how do i copy subtotals without the underlying data? | Excel Discussion (Misc queries) | |||
Copy and paste Internet information into Excel 2003 | Excel Discussion (Misc queries) | |||
how to copy 2350 hyperlink full paths to any column in a worksheet ? | Excel Discussion (Misc queries) |