Combining text into formulas

[Gert.Olesen]

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?

 

[Niek Otten]

Look in HELP for the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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?

 

[Pete_UK]

Give an example of what is in A1, A2 etc.

You would normally use INDIRECT to do this kind of thing, but it won't
work if the file that you want to get data from is closed. You can
download a free add-in, Morefunc, which contains the function
INDIRECT.EXT, and this is meant to allow you to get data from external
closed files.

Hope this helps.

Pete