How to put the name of a cell into another cell?

Question

In Google Sheets, is there a simpler way to put the name of a cell reference into another cell than this?

=concatenate(char(code("A")+COLUMN(D3)-1),row(D3))

Mehper C. Palavuzlar · Accepted Answer · 2012-03-13 16:56:22Z

3

Use this formula:

=ADDRESS(ROW(D3),COLUMN(D3))

Output:

$D$3

14.1k19 gold badges69 silver badges93 bronze badges

answered Mar 13 '12 at 15:45

Siva Charan

6687 silver badges11 bronze badges

That's a bit simpler. Next question: can I write a script function to do the same? As far as I can tell, if I put the cell name into the function argument list, what is passed to the function is the value of the cell, and what I need is a Range object. – Spencer Mar 13 '12 at 15:52

Add a comment |

pnuts · Accepted Answer · 2017-09-26 23:20:25Z

0

Shorter:

=address(3,4)

if the object is to return $D$3.

answered Sep 26 '17 at 23:20

pnuts

15.6k3 gold badges44 silver badges99 bronze badges

Add a comment |

2 Answers 2