Return cell reference as text

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Excel: sum of 7 cells (weeks) in every row of a spreadsheet 1
Automatically Pulling Cells from Different Tabs and Files 1
excel function to get tab name 9
complicate query? 3
Creating dynamic ranges which are named. 1
Cell Linking 5
vlookup type problem 3
How can I make the reference link match the new formatting of its 1

Top