similar to # with '...what about a formula with ' before it

  • Thread starter Thread starter hef
  • Start date Start date
H

hef

What happens if I have the formula with ' before it

b2: 6

c2: '=b2

Now I want c2 to utilize '=b2 to come up with 6... Is this possible?

Thanks,

Hillary
 
=INDIRECT(C2)

but you have to remove the equal sign and the apostrophe, i.e. c2 holds b2,
not '=b2
 
Try INDIRECT()?

Put in C2: =INDIRECT("B2")

This will return the content in cell B2, ie "6"

hth
Max
 
Thanks!!! I have got to look into the Indirect function. This is the
second time you guys have recommended I use it. Off to my Excel book!
:-)
 
Back
Top