1

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?

Improve this question

1 Answer 1

Reset to default
1

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

Resources

Related

Improve this answer
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?
    – Sam Toufaili
    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
    – Luis Ferrao
    Sep 5, 2021 at 11:02

Your Answer

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

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