Return cell reference as text
 

Looking for a formula that will allow me to return a reference used in
another cell as text.

For example
cell tab1!A1 contains formula =tab2!c1 and displays contents of tab2!c1
I'd like cell tab1!b1 to display "=tab2!c1" as text

Return cell reference as text
 

Received an answer to this question in 2nd posting on 8/21/07 "Show cell
reference as text". Thanks Ron Rosenfeld.

http://www.microsoft.com/office/comm...f-9073b94362a5

"tjc" wrote:

Looking for a formula that will allow me to return a reference used in
another cell as text.

For example
cell tab1!A1 contains formula =tab2!c1 and displays contents of tab2!c1
I'd like cell tab1!b1 to display "=tab2!c1" as text