Running a written formula

[RossMcColl]

Hey all,

I have this displayed in a cell as a result of a formula

='C:\[Book2.xls]Sheet1'!$A$1

How can I turn this text answer into actually running the formula so I can find out what is in A1 on Book2? Assuming Book2 is closed.

Thank you,

 

[RossMcColl]

Sorry to bump, but am at work and totally stuck, any ideas peeps?

 

[njimack]

If the cell is formatted as General, Number or a custom number format, it should display the result of the formula, rather than the formula itself.

 

[RossMcColl]

It's a text version of the formula, not the actually formula itself.

So in the cell it has quote marks around it "='C:\[Book2.xls]Sheet1'!$A$1"

 

[NBVC]

Not sure there's not a better way, but here's one way.

If the reference workbook is open, then

=INDIRECT(MID(A2,3,LEN(A2)-3)) where A2 house the string

if the workbook is close, you will have to download and install the morefunc.xll addin from http://xcell05.free.fr/english/

and change the formula to:

=INDIRECT.EXT(MID(A2,3,LEN(A2)-3))