2

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?

1 Answer 1

2

There isn't. I think that the only alternative is to use Google Apps Script as it has setlinkurl

Resources

Related

2
  • 1
    though Google sheets now supports multiple hyperlinks in one cell. So if it's possible using the "Insert Link" functionality, does it mean that I cannot use a formula for it? Commented Aug 11, 2020 at 17:40
  • 1
    @SamToufaili you should mark Rubén's reply as answer, it's is 100% accurate, you can't do what you want using a formula and the only way to achieve something similar is with a Google Apps script Commented Sep 5, 2021 at 11:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.