Text function to pull true value

P

Piers 2k

Hi folks,

Cell contents are something like =March!$C$7, and this calculates correctly.
I need to have a formula in a nearby cell to return the contents of this
cell (a string), not the calculated value. I want to SEE the formula.

Preferably I need to use built in functions, since this will be a new file
most times it's used.

I can do this in VBA, but is there anything built in?

TIA,

Piers
 
P

Pete_UK

If you put an apostrophe in front of the = sign, this turns it to text
so that you can see the formula. You can then copy it to the nearby
cell and go back to the original cell and remove the apostrophe.

Hope this helps.

Pete
 
P

Piers 2k

Thanks Pete, but I need it to be dynamic.

The formula can change source reference, and will also be copied lots, so it
needs to be formula to update automatically.

Thanks though,

Piers
 
H

Harlan Grove

Piers 2k wrote...
....
Preferably I need to use built in functions, since this will be a new file
most times it's used.

I can do this in VBA, but is there anything built in?
Click to expand...

No, there's nothing built in. You have to use VBA or an add-in.
 
Top