1

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.

SnookerFan
  • 1,184

2 Answers2

2

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.

SnookerFan
  • 1,184
0

Basically you confirmed my suspicion and answered this already:

If it does not work in the small example, it won't in the big.

Here are some other related questions, which came to the conclusion, that it is not possible to solve this with excel in this exact way.

https://stackoverflow.com/questions/10181995/create-a-hyperlink-within-an-excel-cell

Hyperlinking a piece of text in Excel

Community
  • 1
Jook
  • 1,945