Forum Discussion
Jacques_Lewalle
Sep 24, 2022Copper Contributor
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
- Sep 24, 2022Hello Jacques_Lewalle
Look into the INDIRECT() function, and ADDRESS() function.
Hope this helps
Georgie Anne
HansVogelaar
Sep 24, 2022MVP
Make sure that the cell with the formula is not formatted as Text.
- Jacques_LewalleSep 25, 2022Copper ContributorThanks. Indirect() was the answer to my question! 🙂