View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default linkable cell like result of a formula

Do you need help..or did it worked?

If this post helps click Yes
---------------
Jacob Skaria


"M" wrote:

Thanks !!
Sorry.... I do not know this function.


"Jacob Skaria" ha scritto nel
messaggio ...

--
If this post helps click Yes
---------------
=HYPERLINK(A1 & A2 & ".html","Link")

Jacob Skaria


"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.