Forum Discussion
Solved
Excel
In an xlsx file, I construct a simple formula by concatenating a text string, e.g. =b28; how to I execute it (evaluate it) as a formula? I tried F2 Enter with no result. Thanks
- Hello Jacques_Lewalle
Look into the INDIRECT() function, and ADDRESS() function.
Hope this helps
Georgie Anne
- Hello Jacques_Lewalle
Look into the INDIRECT() function, and ADDRESS() function.
Hope this helps
Georgie AnneGeorgieAnneThanks! indirect() works!
Make sure that the cell with the formula is not formatted as Text.
- Thanks. Indirect() was the answer to my question! 🙂
