New Contributor

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

4 Replies


Make sure that the cell with the formula is not formatted as Text.

best response confirmed by Hans Vogelaar (MVP)
Hello @Jacques_Lewalle
Look into the INDIRECT() function, and ADDRESS() function.

Hope this helps

Georgie Anne

@GeorgieAnneThanks! indirect() works!

Thanks. Indirect() was the answer to my question!