Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello:
Question: am I able to create a cell that will ahve a link and plain text in the same cell? Example "Visit my site at www.me.com for todays special" The only part I would like to link is the address. Thanks for the help. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Excel won't allow that without a bit of cheating.
Maybe you could place a rectangle from the Drawing toolbar over the characters for the link. Remove the border and assign the hyperlink to that rectangle. If you format the string nicely (blue and underlined???), it may work ok. Jim wrote: Hello: Question: am I able to create a cell that will ahve a link and plain text in the same cell? Example "Visit my site at www.me.com for todays special" The only part I would like to link is the address. Thanks for the help. -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have just placed this:-
Visit my site at http://www.microsoft.com for todays special - into cell M 21. Clicking on the cell takes me to Microsoft's site so it looks as though the answer to your question is yes. Please hit Yes if my comments have helped. Thanks. "Jim" wrote: Hello: Question: am I able to create a cell that will ahve a link and plain text in the same cell? Example "Visit my site at www.me.com for todays special" The only part I would like to link is the address. Thanks for the help. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Okay, this can work - but how did you do it?
"trip_to_tokyo" wrote: I have just placed this:- Visit my site at http://www.microsoft.com for todays special - into cell M 21. Clicking on the cell takes me to Microsoft's site so it looks as though the answer to your question is yes. Please hit Yes if my comments have helped. Thanks. "Jim" wrote: Hello: Question: am I able to create a cell that will ahve a link and plain text in the same cell? Example "Visit my site at www.me.com for todays special" The only part I would like to link is the address. Thanks for the help. |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Jim, I just typed it into the cell exactly as you said! I must admit I
thought it wasn't going to work. Still, you never know! Please hit Yes if my comments have helped. Thanks! "Jim" wrote: Okay, this can work - but how did you do it? "trip_to_tokyo" wrote: I have just placed this:- Visit my site at http://www.microsoft.com for todays special - into cell M 21. Clicking on the cell takes me to Microsoft's site so it looks as though the answer to your question is yes. Please hit Yes if my comments have helped. Thanks. "Jim" wrote: Hello: Question: am I able to create a cell that will ahve a link and plain text in the same cell? Example "Visit my site at www.me.com for todays special" The only part I would like to link is the address. Thanks for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
changing cell value makes the formula plain text | Excel Worksheet Functions | |||
Hyperlinks in plain text? | Excel Discussion (Misc queries) | |||
Converting date into plain text | Excel Worksheet Functions | |||
hyperlinks and plain text in same cell? | Excel Discussion (Misc queries) | |||
Hyperlink from plain text. | Excel Discussion (Misc queries) |