Is it possible to insert a hyperlink which affects text within a cell?
For example:
-----------------
| See this link | <-- Only the word "link" should be highlighted here.
-----------------
Before answering, please be aware of the following: I have seen many tutorials which use a formula (="See this " &HYPERLINK("http://www.superuser.com","link")) in order to insert a hyperlink already; I have 149 words within this cell, spaced out over many lines, and this method does not work with such a large amount of text as it exceeds 255 characters.
Many thanks.
Best Answer
Going by suggestions found on Super User and elsewhere, I have come to the conclusion that the only way to "achieve" the desired results is as follows:
Apply a link to the entire cell (which is the case whether we like it or not) and then to simply format the rest of the text - excluding the desired "link text" - to the standard format of the document, leaving the "link text" resembling a hyperlink. Or, you could reverse the process and colour the "link text" to resemble a hyperlink, leaving the remainder of the text to follow the standard format set by the document.