Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hyperlink info & help needed
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, As an example, 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 ). All help is appreciated Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
Info needed...please help! | Excel Discussion (Misc queries) | |||
Multiple worksheet queries | Excel Worksheet Functions | |||
Removing hyperlink | Excel Discussion (Misc queries) |