Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
How to create a hyperlink in excel, using the text in a cell. | Excel Worksheet Functions | |||
how to hyperlink text to a cell | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions |