in Google Sheets, I am trying to add multiple URLs in one cell, using the Hyperlink Formula.When trying =HYPERLINK("foo.com","Foo") & " some other text " & HYPERLINK("bar.com","Bar")
, the result is = Foo some other text Bar , without the URL links. If I use the "Insert Link" functionality, I am able to add two URls. Is there a way to use the Hyperlink Formula to add multiple URLs in one cell?
Add multiple hyperlinks in one cell, using a Formula
formulasgoogle sheets
Related Topic
- Google Sheets – Extract URL from Cell Containing Hyperlink
- Google-sheets – Formula for Adding Text to End of Cell (contains URL) – How to account for cells ending both with and without a “/”
- Google-sheets – Google Sheets Insert Cell Values into another Cell using formula
- Google Sheets URL – How to Copy URL from Cell and Reference in Script Formula
Best Answer
There isn't. I think that the only alternative is to use Google Apps Script as it has setlinkurl
Resources
Related