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

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

You can put multiple hyperlinks in Google Sheets using the insert link shortcut Control+K.

Select the first work you want to hyperlink and press Control+K > Enter the link URL. Then repeat the same for the 2nd (or subsequent) word you want to hyperlink.

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