Try the HYPERLINK() formula in the next column:

=HYPERLINK(A1, "Link")