Google-sheets – How to get two separate links in one Google Sheet cell
google sheets
I'm trying to figure out how to display two separate words, each with its own unique hyperlink, into a single cell in Google Sheets. Example is in the image below.
Can someone please help me figure out how to do this?
Best Answer
If you type the words in the cell first, you can highlight one word or phrase you'd like to hyperlink and click the link button:
Enter the desired URL and click "Apply"
Repeat as desired.
You can also use the shortcut command+k (Mac) or ctrl+k (PC) to link the word/phrase after highlighting it.
Line breaks inside a Google Sheets cell are encoded as CHAR(10). (The function CHAR returns the character with specified numeric code, and 10 is used to represent new line control character.) So, you should use
Best Answer
If you type the words in the cell first, you can highlight one word or phrase you'd like to hyperlink and click the link button:
Enter the desired URL and click "Apply"
Repeat as desired.
You can also use the shortcut command+k (Mac) or ctrl+k (PC) to link the word/phrase after highlighting it.