Hi
I am looking for a way to combine 3 cell values into a fourth cell
where the result should be treated as a formula and not text.

In order to connect to external data, I must type a rather long
formula, where only 3 digits change. It would therefore be quite good
if I could type the long part of the formula in one cell and make a
column of 3 digit names to be inserted. I have tried CONCATENATE and a
simple =A1&A2 etc., but they all just retun the formula as text. Any
Ideas?