Forum Discussion

pdrandall's avatar
pdrandall
Copper Contributor
May 26, 2023
Solved

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...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    May 26, 2023

    pdrandall 

    In G2 that's simply

    =HYPERLINK("https://doi.org/" & F2)
pdrandall's avatar
pdrandall
Copper Contributor
May 26, 2023

NikolinoDE thank you for your reply. I followed your instructions, but the hyperlinks now contain a SharePoint address (where my Excel file is saved) and not a web address. The first link is:

https://mitre.sharepoint.com/sites/fccc2h/Shared%20Documents/General/Base%20Period%20-%20Sep%2030,%202022%20to%20Sep%2029,%202023/Task%203.%20Strategic%20Support/Subtask%203.3/Article2_BroadbandHealthData/=HYPERLINK(F2,%20%22%22)

 

Also, my dialog box looks a bit different:

 

SergeiBaklan's avatar
SergeiBaklan
MVP
May 26, 2023

pdrandall 

In G2 that's simply

=HYPERLINK("https://doi.org/" & F2)
  • CHURCHMANIG's avatar
    CHURCHMANIG
    Copper Contributor
    Jun 27, 2024
    Made my day just now.
  • pdrandall's avatar
    pdrandall
    Copper Contributor
    May 26, 2023
    Thank you Sergei! That worked.

Resources