Posted to microsoft.public.excel.worksheet.functions
|
|
function to give me cell reference
You can try Ctrl+~
Does that do it for you?
HTH,
Ryan--
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
"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
|