How can you mix text and a hyperlink in the same cell?

M

Mladen_Dj

I believe it is not posible, because excel interpret whole cell as
hyperlink. You can put some text in cell using ="Text " &
HYPERLINK(link_location, friendly_name), but whole result will be formated,
and interpreted as link.
 
D

Dave Peterson

Maybe you can cheat.

Format the text in the cell so that the "hyperlink" part is blue/underscored
(just give it that appearance). Then put a rectangle from the drawing toolbar
(hide the borders) over that text.

Assign your hyperlink to the rectangle (not the cell).
 
Top