Creating a URL in a cell

[elearningdave]

How do you add a hyperlink to a cell value? I've tried doing it the HTML way into a column of type text but that is just showing the raw HTML in Excel.

Thanks

[lastrohimw]

Using formula =HYPERLINK("https://example.com", "Click Here")