Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question
    
as far as I tested - your example does not work, even for the small case. Have you tested it? Try this ="SeeThis"&HYPERLINK("http://www.superuser.com","link") or even better - this way around =HYPERLINK("http://www.superuser.com","link") & " SeeThis" –  Jook Nov 6 '12 at 12:22
    
Yes, of course I tested the example; it didn't work for me, either. However, I did mention that this was a suggestion taken from a tutorial and was not exactly what I was looking for - it was more of a guide which indicates the type of solution that I am seeking. Thank you for your suggestion; unfortunately, however, this also does not work. There is no error message, but nothing actually happens either. The further problem is that even if this smaller version were to work, it would not be suitable as my particular case deals with 149 words in total. –  SnookerFan Nov 6 '12 at 12:30
add comment

2 Answers

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.

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

Hyperlinking a piece of text in Excel

share|improve this answer
add comment
up vote 1 down vote accepted

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.