Want to hyperlink only one word in a cell of Excel

[Iyyappan]

I am pretty sure at some point in the past I've seen text in a cell where there was a hyperlink in just PART of the cell... but I can't for the life of me figure out how to do that now. Any help would be MOST appreciated. Thank.

[JyotiT]

I fear you are mistaken. Having inserted a hyperlink in a cell you can change the character formatting of all but one word to be black with no underlining so that it LOOKS like only the one word is the link - but you can't make only that word ACT as a link. You might be able to insert an object that looks like a cell and can contain rich text, including single hyperlinked words - but I have not found one that works in a quick search.

[-Deven-]

You could cheat and add a rectangle over the word/phrase you want. Then hide its borders and assign the hyperlink to that rectangle. You could even format those characters (if the value in that cell is not a formula) nicely. But it can be a pain if you re-edit the text and change the position of the characters.