The HYPERLINK function creates a hyperlink in a worksheet cell, based on arguments you supply. The syntax is
In this syntax, link_location, a required argument, is a text value that specifies the target of the link, and friendly_name, an optional argument, is the text that will appear in the cell. If friendly_name is omitted, it is assumed to be the same as link_location. Either argument can be a cell reference. Here are a couple of examples:
=HYPERLINK("http://www.microsoft.com","Microsoft Web Site") =HYPERLINK("[\\myserver\myfile.xls]Sheet2!B29")
The first example displays the text "Microsoft Web Site" as a hyperlink that connects to http://www.microsoft.com. Note that you must ...