Excel Hyperlinks- cell content v. hyperlinks
 

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?

Excel Hyperlinks- cell content v. hyperlinks
 

Hi,

If your cell has the Hyperlink() formula then you can delete the
Freindly_Name.

=HYPERLINK("www.company.com","CompanyName")
to just
=HYPERLINK("www.company.com")

Regards,
Bondi

Excel Hyperlinks- cell content v. hyperlinks
 

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?