View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default linkable cell like result of a formula

=hyperlink(a1&a2&".html","Click me")


M wrote:

Hi,

creating a link in cell A3 using this formula: =A1 & A2 & ".html"
the format of the cell appears right, but none link if I click on it.

I have to copy the cell (only value), push F2 and Enter to do a linkable
cells (so I can call correctly the url).

Is there another way to have the A3 already as Hpertestual?

Thanks to all
M.


--

Dave Peterson