Excel geeks, please...

i'm doing an NVQ level 2 at mo using Excel as part of it, i'm poo with it too (IF statements and filters at the moment )

Originally Posted by Filipe M.

As an example, let's say I have 2+A1 stored as text in cell A2. Now I want cell A3 to pick the contents of cell A2, which would be the text, and evaluate it as a formula (essentially the same as inputting =2+A1 in cell A3). Nope, concatenating a text string with the = sign before won't cut it... been there, done that.

My first thoughts when I read the above were, =INDIRECT("=2+A1") ... but...

Originally Posted by Filipe M.

Already solved, thank you for your time!

So now I'm not going to tell you!! Wait a min...

Originally Posted by anna

change text cells to number cells???

Nope, tried that, not that simple but thanks anyway.

Originally Posted by Baph

My first thoughts when I read the above were, =INDIRECT("=2+A1") ... but...

No go, also tried that. The solution involves an old "Evaluate" expression that comes from Excel 4, but only works within named ranges (or VBA). So as long as I can use a named range I'm a happy bunny.