function help!

[happydz]

Supposing that column C2 contains the function: =LIEN_HYPERTEXTE(B2;A2)
how can I delete both column B2 and A2 without affecting the column C2?

 

[Joe4]

You could use the INDIRECT function (though if you are using a different language version oif Excel, I am not sure what it is called in that one).
The function would be structured like:

=LIEN_HYPERTEXTE(INDIRECT("B2;A2"))

 

[6StringJazzer]

You cannot. How could you expect to delete the data used by your function and yet not affect the result of the function?

I am not sure what you are really describing because you refer to deleting columns but you are referring to cells. What is it exactly that you want to delete?

And last, your function is a custom function so we don't even know what it does.

 

[6StringJazzer]

if you are using a different language version oif Excel

Oh, is LIEN_HYPERTEXTE another language for the HYPERLINK function?