Hyperlinking text
If you want to link a specific URL to text within a cell of your spreadsheet, you can insert a HYPERLINK formula into the desired cell. For example:
=HYPERLINK(“www.google.com”, “Google”)
The same goes for an email- just put the email address in between the (" ")