Forum Discussion
Insert a hyperlink for a limited amount of text within a cell?
I'm in the process of converting a number of google sheets over to excel.
Many of these google sheets carry hyperlinks to other docs.
How can attach a hyperlink to select (limited) text within a cell.
Is that possible?
Thx!
Cyndi
5 Replies
Could you explain a bit more fully what you mean? Some examples would help. What are the current hyperlinks? What do you mean by limited text? Are the existing hyperlinks to "other docs" as your message says, or to cells within a doc? And by "other docs" do you mean Excel spreadsheets?
You see the need....your initial description leaves a lot to be clarified before we can offer any specific help, if what you're seeking is even possible.
Fair enough! Thanks for asking mathetes
These links go to other documents (currently google sheets, hopefully moving all google sheets over to Excel.
In a single cell in a google sheet, I am able to insert text of which only some of that text is hyperlinked to external documents.
Here is an example of one cell in a google sheet that has a lot of text, but only a portion of that text highlighted as reference to a hyperlink to an external document.
Does this help better define what I'm looking for?
Thanks!
Cyndi
In a single cell in a google sheet, I am able to insert text of which only some of that text is hyperlinked to external documents.
Here is an example of one cell in a google sheet that has a lot of text, but only a portion of that text highlighted as reference to a hyperlink to an external document.
Does this help better define what I'm looking for?
It does indeed. HansVogelaar has already told you that Excel doesn't support the kind of linking you're seeking. You example, though, raises another question in my mind: why are you using spreadsheets for this, whether Google Sheets or Excel? Word )and I'm pretty sure Google Docs) also handles tables--arrays of textual data in rows and columns--and it looks like that's essentially what you're using the spreadsheet for: its rows and columns. If most of what you're working with are words, and text documents--i.e., NOT numbers and formulas, which is what Spreadsheets are for--then consider using Word or Google Docs.
