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
GeorgieAnne
Sep 24, 2022Iron Contributor
Hello Jacques_Lewalle
Look into the INDIRECT() function, and ADDRESS() function.
Hope this helps
Georgie Anne
Look into the INDIRECT() function, and ADDRESS() function.
Hope this helps
Georgie Anne
- Jacques_LewalleSep 25, 2022Copper Contributor
GeorgieAnneThanks! indirect() works!