linkable cell like result of a formula

M

M

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

Dave Peterson

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

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.
Click to expand...
 
Top