Google-sheets – How to open multiple URLs in Sheets using one cell

google sheetsgoogle-apps-scriptgoogle-sheets-cell-format

I have been frequently using concatenate to combine cells and strings to render URLs in cells. The purpose of these URLs is to open specific pages to review the information on those pages.

I am looking to create a comma separated (or other) list in one cell where I can open all of the links in separate tabs (especially if it can be in a new window).

Is there a way of using something like target="_blank to make Sheets open those links? Would it only be possible using the script editor somehow?

Best Answer

Impossible. The content of a cell is rendered as a hyperlink under certain conditions (when it's detected as a hyperlink or pasted in as rich text with a hyperlink, or contains the hyperlink formula). In any of these cases, the entire cell's content will be one link. It will not contain multiple links.

Related Solutions

Google-sheets – How to insert formatted links in Google Sheet concatenations

As the OP already realized, getValue() and getValues() return a string object for cells containing an hyperlink and the value returned when the object is concatenated is the link text that the OP referred as the alias.

We could use getFormula() and getFormulas() to get the cells formulas and to parse the URL from the them. See Extract the link text and URL from a hyperlinked cell for answers showing how to do this.

Google-sheets – Convert multiple currencies and total the results in one cell

The function googlefinance provides the current exchange rates for all these currencies. For example, this converts the amounts in A1, B1, C1, D1 from (GBP, EUR, DKK, SKK) to GBP, and adds them.

=A1 + B1*googlefinance("currency:EURGBP") 
    + C1*googlefinance("currency:DKKGBP") 
    + D1*googlefinance("currency:SKKGBP")

Best Answer

Related Solutions

Google-sheets – How to insert formatted links in Google Sheet concatenations

Google-sheets – Convert multiple currencies and total the results in one cell

Related Topic