formula to choose a hyperlink from a cell
 

I have a cell which contain a hyperlink.
Now I want a formular to pick the hyperlink in this cell.(result is a text)
Example:
cell A1: "Music" (it was formated as blue and underline by Excel) and
have a hyperlink: "C:/my music/music.html"
Now I want cell A2 have text "C:/my music/music.html" (use a formula to do it)

Sorry for my English
Thanks.

formula to choose a hyperlink from a cell
 

Hi Luong,
see
http://www.mvps.org/dmcritchie/excel...perlinkaddress

to install a User Defined Function
see http://www.mvps.org/dmcritchie/excel....htm#havemacro
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Luong Vinh Tu" wrote in message ...
I have a cell which contain a hyperlink.
Now I want a formular to pick the hyperlink in this cell.(result is a text)
Example:
cell A1: "Music" (it was formated as blue and underline by Excel) and
have a hyperlink: "C:/my music/music.html"
Now I want cell A2 have text "C:/my music/music.html" (use a formula to do it)

Sorry for my English
Thanks.