The HYPERLINK function creates a shortcut to open a document stored on a network server, an intranet or the Internet.
= HYPERLINK(link_location, [friendly_name])
- Link_location is required, the link to the file (e.g., internet, network server).
- Friendly_name is optional. The name you gave to the link to the location. When friendly_name is omitted, the function uses link as the name.
=HYPERLINK("https://excelnotes.com/","your best excel source"). B2 displays the name "you best excel source".
=HYPERLINK("https://excelnotes.com/"), the friendly name is omitted, so the result returns the link itself as the friendly name.