Text in Cell as Formula
 

Peo + Julie Many thanks for your answer with the last query.

I have another similar question; I would like to use values form a
different spreadsheet, and this method [INDIRECT()] fails.

i.e. I type the link (as text) from a different spreadsheet in a cell in the
current spreadsheet and use this method to call a value in a cell.

Appreciate your help.