HYPERLINK - insert within a text sentence

G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can an "inline" hyperlink be created in a cell? 1
Can you hyperlink to a hyperlink? 1
Can UDF return a customized hyperlink? 3
How to convert hyperlink in Excel to show hyperlinked address? 5
Insert Text Hyperlink in Body of Email 1
How to insert a hyperlink in text in a paragraph 3
The hyperlink reference doesn't changes when I insert Rows and co. 2
Using a hyperlink within a worksheet 2

Top