How do you have both a hyperlink and "regular" words in a cell?
 

If I copy a hyperlink into a cell, or make a hyperlink in the cell, all the
contents turn into a hyperlink. I don't want that.

How do you have both a hyperlink and "regular" words in a cell?
 

Select the range of cells. Rightclick --Remove hyperlink
--
If this post helps click Yes
---------------
Jacob Skaria


"kaliszek" wrote:

If I copy a hyperlink into a cell, or make a hyperlink in the cell, all the
contents turn into a hyperlink. I don't want that.

How do you have both a hyperlink and "regular" words in a cell?
 

The Insert|Hyperlink type and the =hyperlink() type both apply to the entire
cell.

But you can 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).

kaliszek wrote:

If I copy a hyperlink into a cell, or make a hyperlink in the cell, all the
contents turn into a hyperlink. I don't want that.

--

Dave Peterson