Hi,

Can anybody tell how to add a hyperlink in a cell that already contains
text? When I try the option to add a link is not available.

Thank you,

you can always concatenate the hyperlink function with text:


=HYPERLINK("http://www.google.com","seek and yea shall find") & CHAR(10) &
"Ask and ...."

--
Gary's Student


"Richard" wrote:

Hi,

Can anybody tell how to add a hyperlink in a cell that already contains
text? When I try the option to add a link is not available.

Thank you,

Well, assuming your cell isn't protected, you shouldn't have a problem. I
can't see a way of making part of the contents into a link but you could
reformat part of the cell to look like ordinary text so that your link is
obvious to anyone.

"Richard" wrote:

Hi,

Can anybody tell how to add a hyperlink in a cell that already contains
text? When I try the option to add a link is not available.

Thank you,