I would like to have text and a functioning hyperlink in the same cell in
Excel.
I would like to have text and a functioning hyperlink in the same cell in
Excel.
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 [email protected]> wrote in message
news:[email protected]...
>I would like to have text and a functioning hyperlink in the same cell in
> Excel.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks