See http://www.mvps.org/dmcritchie/excel/buildtoc.htm
to extract the hyperlinkaddress with a function from object
type hyperlinks (Ctrl+K).

There is also one to extract from HYPERLINK Worksheet Function,
but they would have to be explicit not derived from formulas.
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"herpetafauna" wrote in message ...
I have a column containing company names. Each company name has the hyperlink
address to the company website. This is shown in the ScreenTip when the
mouse is hovered over the cell and may be individually obtained using 'edit
hyperlink...'. I wish to change the cell content to the blue underlined
hyperlink address and not the company name. What can I do?