ability to create hyperlink (formulas)

It would be useful to be able to create a formula that generates a clickable hypelink (like from concatenate formula)