Forum Discussion

pdrandall's avatar
pdrandall
Copper Contributor
May 26, 2023

Making concatenated links clickable

I have a column of digital object identifiers (DOIs) that are not themselves links. In order to make them links, I used a concatenate function (e.g., =CONCAT("https://doi.org/", F2) in the adjacent c...
  • SergeiBaklan's avatar
    SergeiBaklan
    May 26, 2023

    pdrandall 

    In G2 that's simply

    =HYPERLINK("https://doi.org/" & F2)

Resources