Reference to cell containing "HYPERLINK" function only returns friendly name text

[agmanderson]

I have a spreadsheet with a column of formulae, like this example:

=HYPERLINK("http...." & C2, left(B2,8))

Now let's say that formula is in cell D2. If I then go elsewhere on my spreadsheet and enter the formula =D2, all I get is plain text of the friendly name (argument 2 of the HYPERLINK function) and not the full, clickable hyperlink which is what I want (for complicated reasons).

Is there a way of getting the full hyperlink to appear in another cell, or must I re-generate it with another HYPERLINK function which will need much more complicated referencing (as it will be on a different sheet on a different, dynamically calculated row number)?

 

[sergioMabres]

Hi Agm,
When you reference the cell D2 in an other cell you get its Text value, not its hyperlink setting.
In order to have the same hyperlink in another cell you need a formula like this:

[COLOR=#574123]=HYPERLINK("http...." & C2, D2)[/COLOR]

Cheers
Sergio