Hyperlinks in Google Spredsheets

• It can be really useful to include a hyperlink within a Google Doc spreadsheet
• Documentation on this feature I found can be tricky to implement
• The following shows how you can quickly insert this.

Format 

• You can use the following format as a template to change as appropriate :

 =HYPERLINK("www.wikipedia.org", "Search Wikipedia") 

• This will produce the link shown in the image at the toop of the post
• I also found the following works using a semicolon in place of a colon 

  =HYPERLINK( "www.wikipedia.org" ; "Search Wikipedia")

Help Syntax Missing Quote Information

• In a cell you can type '=HYPER' then autocomplete will show the syntax

• This shows the format as 

HYPERLINK(URL, cell_text)

• Which I found did _not with a 'Parse Error' was  : 

=HYPERLINK(www.wikipedia.org, Search Wikipedia)
=HYPERLINK(www.wikipedia.org, "Search Wikipedia")
=HYPERLINK("www.wikipedia.org", Search Wikipedia)
=HYPERLINK("www.wikipedia.org", Wikipedia)