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.