Question: how to create hyperlink formula in excel?
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.