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.