Convert String to Function Reference

V

ViestaWu

Cell D23's value is "$C$2", I want to use Function "Cell" to get the content
of cell C2. =Cell("centents", D23) but the result is "$C$2" instead of its
content. Is there any way that can help me convert string $C$2 to reference
C2?
 
C

carlo

Cell D23's value is "$C$2", I want to use Function "Cell" to get the content
of cell C2. =Cell("centents", D23) but the result is "$C$2" instead of its
content. Is there any way that can help me convert string $C$2 to reference
C2?
Click to expand...

try

=indirect(D23)

hth

Carlo
 

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

Ignoring Text using the AND OR IF function 0
dynamic cell reference within a text string 4
Excel VBA 1
If condition for Blank Cell 4
Prevent function errors caused by cutting & paste or drag & drop 1
countifs Function not giving desired result with date criteria 2
Copying formulas across columns 2
change the color of cell background based on a result 2

Top