A new feature was recently released for Google Sheets which allows you to add multiple hyperlinks in the same cell.
You can now do so by highlighting specific words or strings in a cell and clicking on the link button in the toolbar (or Ctrl+K/Cmd+K if you prefer keyboard shortcuts!)
Repeat this process to add multiple hyperlinks in the same cell.
When hovering over a cell that contains multiple links, they are displayed sequentially, in a box below the cell:
Lastly, if you right-click on a cell containing multiple hyperlinks, you can open them all at once!