Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

I want to concatenate an =, a cell value with a number and a letter to make a cell reference formula

Cell D3 has a value of 3 Cell A3 has a value of 047853002508

In cell I3 I used the following formula: =CONCATENATE("=A",D3)

The result is cell I3 has a value =A3. I want the value to be 047853002508 which would be the result of the cell reference =A3. If I type =A3, the result is 047853002508.

Why doesn't the concatenate function treat the result as a cell reference?

I assume I'm doing something wrong and I hope I explained this correctly.