Look in HELP for the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in message ...
| 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?