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.
="SeeThis"&HYPERLINK("http://www.superuser.com","link")
or even better - this way around=HYPERLINK("http://www.superuser.com","link") & " SeeThis"