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?