View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] dawsonsc@gmail.com is offline
external usenet poster
 
Posts: 7
Default 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