Google Sheets has a formula called Hyperlink.
HYPERLINK(url, [link_label])
Example
HYPERLINK(“http://www.google.com/”, “Google”)
Where url is The full URL of the link location enclosed in quotation marks, or a reference to a cell containing such a UR...