If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hyperlinks
Is there a way in Excel 2003 to have text and a hyperlink in one cell? For
Example: Cell A1 should read: For More Information, please see www.example.com And only the hyperlink would be the "hyperlink" leaving the text just plain text. I've tried concatenating, but it either removes the hyperlink all together or makes everything the hyperlink. |
#2
|
|||
|
|||
Hyperlinks
no
The cell is either a hyperlink or not. If you put two cells together and formatted nicely, it might LOOK like the text is not hyperlinked -- Gary''s Student - gsnu200819 "amezera" wrote: Is there a way in Excel 2003 to have text and a hyperlink in one cell? For Example: Cell A1 should read: For More Information, please see www.example.com And only the hyperlink would be the "hyperlink" leaving the text just plain text. I've tried concatenating, but it either removes the hyperlink all together or makes everything the hyperlink. |
#3
|
|||
|
|||
Hyperlinks
You could cheat.
You could add a rectangle from the Drawing toolbar (hide the borders!) just over the text you want. Then assign a hyperlink to that rectangle. Format the characters under the rectangle so that it looks like a hyperlink (blue underlined). amezera wrote: Is there a way in Excel 2003 to have text and a hyperlink in one cell? For Example: Cell A1 should read: For More Information, please see www.example.com And only the hyperlink would be the "hyperlink" leaving the text just plain text. I've tried concatenating, but it either removes the hyperlink all together or makes everything the hyperlink. -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|