| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
linkable cell like result of a formula
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
linkable cell like result of a formula
-- 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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
linkable cell like result of a formula
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Bar F9 Result differs from cell result??? | Excel Worksheet Functions | |||
| multiply formula where 1 cell has a (sumif) formula as a result | Excel Worksheet Functions | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
| Question: Cell formula or macro to write result of one cell to another cell | Excel Programming | |||
Linear Mode
