URL function
 

Folks:


In column #1 of my spreadsheet, I have a list of hyperlinks. When I hold my
mouse over these links, the URL (or email address) associated with these
links would show up.

* Is there an Excel function (or keyboard combination) that I can use to
copy the URL (or email address) associated with my links to column #2 ?


Thanks,
JoJo

URL function
 

http://www.EXCELGAARD.dk/Lib/UDFs/READURL/



JoJo wrote:
Folks:


In column #1 of my spreadsheet, I have a list of hyperlinks. When I
hold my mouse over these links, the URL (or email address) associated
with these links would show up.

* Is there an Excel function (or keyboard combination) that I can
use to copy the URL (or email address) associated with my links to
column #2 ?


Thanks,
JoJo