The formula to use is

=HYPERLINK(actual_address, friendly_address)

where actual_address is the full link to the website (or other excel
sheets/files), and friendly_address is what is shown in the Excel cell
- underlined and coloured blue. If friendly_address is missing, the
actual_address is shown.

Hope this helps.

Pete