Question: how to create a hyperlink in excel from a formula?
Answer: In cell C2, type the formula: =HYPERLINK(B2,A2)
Press Enter, to see the hyperlink in C3. It uses the link in cell B2, and the text in cell A2 is shown in cell C2, as the Friendly Name.
Copy the formula down to the remaining rows.