Hyperlink shouldn't work in text functions: https://help.salesforce.com/articleView?id=fixing_formula_errors.htm&type=0