linkable cell like result of a formula

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

 

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

 

[Jacob Skaria]

--
If this post helps click Yes

 

[M]

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

 

[Jacob Skaria]

Do you need help..or did it worked?

If this post helps click Yes