Hyperlink in cell with line breaks

When you have a cell with few link breaks in it, is it possible to
hyperlink only one line?

For example, if a cell had these contents

LINE ONE
LINE TWO
HYPERLINK THIS TEXT ONLY

How do I hyperlink the last line only?

Thanks for the reply... seems like this should be possible....
Special-K wrote:
> Not sure you can. In your example it would be better to format that cell
> into three columns and reserve the third column for the hyperlink
>
>
> --
> Special-K
>
>
> ------------------------------------------------------------------------
> Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
> View this thread: http://www.excelforum.com/showthread...hreadid=562488

The cell gets the hyperlink--not the text in the cell.

But you could cheat.

You could put a rectangle over the last line (hide the borders) and then assign
the hyperlink to that rectangle.

You could even format that bottom line to make it look like a hyperlink.

[email protected] wrote:
>
> Thanks for the reply... seems like this should be possible....
> Special-K wrote:
> > Not sure you can. In your example it would be better to format that cell
> > into three columns and reserve the third column for the hyperlink
> >
> >
> > --
> > Special-K
> >
> >
> > ------------------------------------------------------------------------
> > Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
> > View this thread: http://www.excelforum.com/showthread...hreadid=562488

--

Dave Peterson

The rectangle can be found on the Drawing toolbar.

Dave Peterson wrote:
>
> The cell gets the hyperlink--not the text in the cell.
>
> But you could cheat.
>
> You could put a rectangle over the last line (hide the borders) and then assign
> the hyperlink to that rectangle.
>
> You could even format that bottom line to make it look like a hyperlink.
>
> [email protected] wrote:
> >
> > Thanks for the reply... seems like this should be possible....
> > Special-K wrote:
> > > Not sure you can. In your example it would be better to format that cell
> > > into three columns and reserve the third column for the hyperlink
> > >
> > >
> > > --
> > > Special-K
> > >
> > >
> > > ------------------------------------------------------------------------
> > > Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
> > > View this thread: http://www.excelforum.com/showthread...hreadid=562488
>
> --
>
> Dave Peterson

--

Dave Peterson