Is there a way for me to make only part of the text in a cell a
hyperlink?
For example, if my cell text says:

Open up the full and part report.
I want that if my user clicks the word "full", one thing opens, if
clicks "part", something else opens.

Is there any way to do this?


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=476358

One hyperlink per cell.

But you could cheat. Put a rectangle (from the drawing toolbar) over each word.

Assign different links to each rectangle.

Format the rectangle so the borders don't show. Format the text in
Blue/underscore so that it looks like a hyperlink.

You might even fool your users!

tkaplan wrote:

Is there a way for me to make only part of the text in a cell a
hyperlink?
For example, if my cell text says:

Open up the full and part report.
I want that if my user clicks the word "full", one thing opens, if
clicks "part", something else opens.

Is there any way to do this?

--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=476358

--

Dave Peterson

great idea:)
Thank you!


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=476358