How to return the cell formula rather than the value
Solution 1:
To convert a text string into a valid cell reference in Excel, you can use the INDIRECT function.
From the above link:
For example, take a look at the INDIRECT function below.
Explanation: =INDIRECT(A1) reduces to =INDIRECT("D1"). The INDIRECT function converts the text string "D1" into a valid cell reference. In other words, =INDIRECT("D1") reduces to =D1
