Excel Hyperlinks- cell content v. hyperlinks

[Guest]

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?

 

[Bondi]

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

 

[David McRitchie]

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.