Excel

[Jacques_Lewalle]

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

[#2]

@Jacques_Lewalle 

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

[#3 · Accepted solution]

Hello @Jacques_Lewalle
Look into the INDIRECT() function, and ADDRESS() function.

Hope this helps

Georgie Anne

[#4]

@GeorgieAnneThanks! indirect() works!

[#5]

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