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.

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.

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