Combining text into formulas
 

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?

Combining text into formulas
 

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?

Combining text into formulas
 

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

On Sep 17, 8:58*am, wrote:
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?