ExcelBanter - Convert String to Function Reference

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Convert String to Function Reference (https://www.excelbanter.com/excel-worksheet-functions/167453-convert-string-function-reference.html)

ViestaWu

Convert String to Function Reference

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?

carlo

Convert String to Function Reference

On Nov 27, 3:44 pm, ViestaWu wrote:
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?

try

=indirect(D23)

hth

Carlo

All times are GMT +1. The time now is 01:45 AM.