How do I link text to a URL in a Google Docs spreadsheet? [duplicate]

Question

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

When I paste a URL into a cell in a Google Docs spreadsheet, it turns into a nice blue, underlined hyperlink. It also gives me the option to remove the hyperlink without clearing the cell:

Is there a way to hyperlink arbitrary text to a URL?

Answer 1

Enter the hyperlink formula for it to convert said custom text to an external link of your choice.

=hyperlink("www.example.com";"attack of the green honda civic")

From: Entering links - Google Docs help.

Answer 2

Google Docs automatically recognises text that should be a hyperlink.

I am guessing that you have removed a hyperlink using the method you describe (clicking Remove). To add it back in you just need to right-click the cell and click Show Hyperlinks