Hi Ashish. Thanks for the answer. So there's definitely no dynamic way to
do it?

Would you know if there's a way to get a column in a summary sheet to
display the names of all the other sheets?

e.g.

Col A (in Sheet4):
Sheet1
Sheet2
Sheet3





"Ashish Mathur" wrote:

Hi,

While on cell A1, go to Data Text to columns Delimited and select Other.
in the other box, type = and click on next. in the destination cell box,
select B1. Click on Finish. please note that this is not a dynamic
solution I.e. if the formula changes in cell A1, then the result in cell C1
will not change.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Josh Craig" wrote in message
...
Is there a function that returns the formula in another cell in text?

For example, if cell A1 has the formula:

=Sheet2!B2

I want B1 to say in text: Sheet2!B2