Hyperlink within formula
 

I was wondering if there was a way so that my hyper link would be
active for a specific word in my sentence instead of the whole line of
text. Right now I have this formula:

="Enter the applicable code for each entry on the form. The codes are
listed on the "&hyperlink("http:\\www.programpaymentlist.com","P rogram
Payment List")&"."

But it isn't achieving what I hoped. I would like the hyper link to
only show for the words "Program Payment List" not the whole line of
text.

Is there anyway to do what I am asking?

Thanks

Hyperlink within formula
 

Hyperlinks (=hyperlink() or insert|hyperlink) will apply to the whole cell.

But you could cheat.

Add a rectangle over the words in the cell. Hide its borders. Assign a
hyperlink to that hidden rectangle.

If you enter the string in the cell as text (not a formula), you could even
format the characters under the rectangle so that it looks like a hyerlink
(blue, underlined).

But if you enter a formula (or numbers), then you can't do this kind of
character by character formatting.

wrote:

I was wondering if there was a way so that my hyper link would be
active for a specific word in my sentence instead of the whole line of
text. Right now I have this formula:

="Enter the applicable code for each entry on the form. The codes are
listed on the "&hyperlink("http:\\www.programpaymentlist.com","P rogram
Payment List")&"."

But it isn't achieving what I hoped. I would like the hyper link to
only show for the words "Program Payment List" not the whole line of
text.

Is there anyway to do what I am asking?

Thanks

--

Dave Peterson

Hyperlink within formula
 

On May 7, 2:41 pm, Dave Peterson wrote:
Hyperlinks (=hyperlink() or insert|hyperlink) will apply to the whole cell.

But you could cheat.

Add a rectangle over the words in the cell. Hide its borders. Assign ahyperlinkto that hidden rectangle.

If you enter the string in the cell as text (not a formula), you could even
format the characters under the rectangle so that it looks like a hyerlink
(blue, underlined).

But if you enter a formula (or numbers), then you can't do this kind of
character by character formatting.



wrote:

I was wondering if there was a way so that my hyper link would be
active for a specific word in my sentence instead of the whole line of
text. Right now I have this formula:

="Enter the applicable code for each entry on the form. The codes are
listed on the "&hyperlink("http:\\www.programpaymentlist.com","P rogram
Payment List")&"."

But it isn't achieving what I hoped. I would like the hyper link to
only show for the words "Program Payment List" not the whole line of
text.

Is there anyway to do what I am asking?

Thanks

--

Dave Peterson

Thanks Dave, that is a great idea!