Hyperlink friendly_name
If you use the hyperlinks that open webpages in Excel you may want to change the text that identifies the link(called Anchor text in webspeak).
Usually you can just type a URL in a cell and it automatically converts to a Hyperlink. This works fine for linking to Domains, however when I link to individual pages the link looks long and ugly. Fortunately Excel provides a way to choose the text that displays. Excel calls it friendly_name.
To control the text that displays for a Hyperlinked cell, enter your link as follows:
Syntax
=HYPERLINK(link_location,[friendly_name])
Example
=HYPERLINK(“http://www.automateexcel.com”,”Automate Excel Home Page”)
Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
Get answers right away at our AE Excel Support Forums!
I tried to use the above excel formula. Problem: my original link locations contains “.” and “_” and blanks, e.g.
=HYPERLINK(“http://intranet…/ACT_8.01/act.txt”;”Name”)
The original cell content e.g. is =Hyperlink (…Angola Telecom /ang .txt”;
If I click Edit Hyperlink
the Adress reads like
Angola%20Telecom%20/ang%20.txt
This address however cannot be resolved if I click the cell and funny enough, the %20 are not displayed as cell content.
If I replace the %20 now with the Original character by means of the Hyperlink Editor, the link works fine!
Question: what must be done in order to automate the conversion of many links like this by means of VBA?
Re Resonse 2: Problem Solved. The address could not be resolved because the strings taken from an Excel cell contained also blanks. After the blanks have been all removed, the hyperlink works fine.