How do I add a hyperlink to a cell in Google Spreadsheets?

Question

In Excel, I can easily add a hyperlink to a cell by choosing the corresponding toolbar button. How do I do the same thing in a Google Doc spreadsheet?

I don't see any corresponding toolbar button or menu item. I'm using a Google Apps, if that makes any difference.

Answer 1

It is the HYPERLINK function in the format of =HYPERLINK(URL; TEXT TO DISPLAY)

e.g.

=HYPERLINK("www.google.co.uk"; "Google")

Do not forget there is semicolon used between the actual link from the text.