This is a documented function within Google Spreadsheet, but I never thought of it before, and had no need for it until recently. Now that I want to be able to have a URL / link for data in a cell, without changing the content of the cell, I use HYPERLINK. Here's how!
=HYPERLINK ("URL","text here") and voila!
There's more information on this located here, but the concept is simple.