Specifying a URL or file path directly in a cell automatically formats it as a hyperlink, but this can be set with a function.
This makes it possible to control the link destination in a variable manner.
How it works
=HYPERLINK(link_location, friendly_name)
| Name | Omission | Explanation |
|---|---|---|
| link_location | Required argument. | Specify the path or URL of the file to jump to. Up to 255 characters. |
| friendly_name | Value specified in "link_location". | Specify what to display in the cell. |
Demonstrate
If you omit the friendly_name, the cell will display the link as is.
If an friendly_name is set, the cell will display the friendly_name.
---