I need to convert a formula in a cell, a reference to an other spreadsheet,
to text. I.e. Cell 'Spreadsheet1'!A6 contains formula: ='spreadsheet2'!B4
in cell 'Spreadsheet1!H6 i want the text 'spreadsheet2'!B4 to appear.

How do I do that?