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))
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityIn 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))
Use this formula:
=ADDRESS(ROW(D3),COLUMN(D3))
Output:
$D$3