Excel automatic hyperlinks

After years of not wanting Word and Excel to automatically turn things into hyperlinks, the one time I want them to they refuse.

I have a list of strings in Excel which I am concatenating with a string to create a URL, I would like the resulting URL to be a clickable hyperlink but Excel won't play ball. Is this possible?

Take a look at Hyperlink worksheet function.

Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet. When you click the cell that contains the HYPERLINK function, Microsoft Excel opens the file stored at link_location.

Syntax

HYPERLINK(link_location,friendly_name)

For example:

=HYPERLINK(B1, "Click for report")