How can I put multiple hyperlinks inside the same cell

Question

In Google Sheets I want to put multiple hyperlinks in the same cell.

I've tried multiple options, but all returned errors.

When I put a single link in a cell, it works fine:

=HYPERLINK("mylink.com"; "link1")

The following formula didn't work for multiple links, even if I tried changing commas for semi-colons etc.:

=HYPERLINK("mylink.com"; "link1");
 HYPERLINK("mylink.com"; "link2");
 HYPERLINK("mylink.com"; "link3")

If anyone knows how to do it, please let me know.

Answer 1

You can't do it using the HYPERLINK function but there is an alternative approach.

Insert Link Shortcut

You can put multiple hyperlinks in Google Sheets cells using the "insert link" shortcut:

         - PC:   CTRL+K

         - Mac: CMD+K

Steps

1. Select the first word you want to hyperlink.
2. Press CTRL+K
3. Enter the link URL.
4. Repeat the steps above for the next, and subsequent words, you want hyperlinked.

Resource: Keyboard shortcuts for Google Sheets