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

I would like to have text and a functioning hyperlink in the same cell in
Excel.

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

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.


"Brenda D" <Brenda wrote in message
...
I would like to have text and a functioning hyperlink in the same cell in
Excel.

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

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).

Brenda D wrote:

I would like to have text and a functioning hyperlink in the same cell in
Excel.

--

Dave Peterson