Page 480 - Excel 2013 All-in-One For Dummies

462 Using the HYPERLINK Function
How to tell a UNC from a URL address and when to care
The address that you use to specify a remote hyperlink destination comes in two basic fla- vors: UNC (Universal Naming Convention) and the more familiar URL (Universal Resource Locator). The type of address that you use depends on whether the destination file resides on a server on a network (in which case, you use a UNC address) or on a corporate intranet or the Internet (in which case, you use a URL address). Note that URLs also appear in many flavors, the most popular being those that use the Hypertext Transfer Protocol (HTTP) and begin with http:// and those that use the File Transfer Protocol (FTP) and start with ftp://.
The UNC address for destination files on net- work servers start with two backslash charac- ters (\\), following this format:
\\server\share\path\filename
In this format, the name of the file server con- taining the file replaces server, the name of
the shared folder replaces share, the direc- tory path specifying any subfolders of the shared folder replaces path, and the file’s complete filename (including any filename extension, such as .xls for Excel worksheet) replaces filename.
The URL address for files published on web- sites follows this format:
internet service//internet
address/path/filename
In this format, internet service is replaced with the Internet protocol to be used (either HTTP or FTP in most cases), internet address is replaced with the domain name (such as www.dummies.com) or the number assigned to the internet server, path is the directory path of the file, and filename is the complete name (including filename extensions such as .htm or .html for web pages).
When specifying the arguments for a HYPERLINK function that you type on the Formula bar (as opposed to one that you create by using the Insert Function feature by filling in the text boxes in the Function Arguments dialog box), you must remember to enclose both the link_location and friendly_name arguments in closed double quotes. For example, to enter
a HYPERLINK function in a cell that takes you to the home page of the For Dummies website and displays the text “Dummies Home Page” in the cell, enter the following in the cell:
=HYPERLINK(“http://www.dummies.com”,”Dummies Home Page”)