It doesn't look like you can create a hyperlink as part of a text string.
The whole text string has to be the link.

Example: =HYPERLINK("http://www.cnn.com","Click here to go to CNN")

Dave
--
Brevity is the soul of wit.


"Jane" wrote:

how do I insert a hyperlink with a sentence?

"The new store list has been updated: hyperlink to list"
I need this all within one cell yet have the hyperlink work.

I copy and pasted my hyperlin to the end of my sentence and it UN-hyperlinked.

help!

thansk! jane