Link and plain text in the same cell
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. |
Link and plain text in the same cell
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 |
Link and plain text in the same cell
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. |
Link and plain text in the same cell
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. |
Link and plain text in the same cell
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. |
All times are GMT +1. The time now is 11:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com