A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Hyperlinks



 
 
Thread Tools Display Modes
  #1  
Old December 9th, 2008, 06:04 PM posted to microsoft.public.excel.misc
amezera
external usenet poster
 
Posts: 14
Default 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  
Old December 9th, 2008, 06:15 PM posted to microsoft.public.excel.misc
Gary''s Student
external usenet poster
 
Posts: 7,584
Default 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  
Old December 9th, 2008, 06:45 PM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 19,791
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:26 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.