How to convert a cell address to text?

[Jay_Warner]

Each cell has an address, such as DA2 [Col DA, row 2].  How can I convert this to a text, such as "DA2", that I can then put into another cell [preceded with a ' to keep it a text] to indicate the location of the first cell?

[#2 · Accepted solution]

@Jay_Warner 

As variant

=ADDRESS(ROW(DA2),COLUMN(DA2),1,1)

[#3]

Works!  Many thanks.

@Sergei Baklan 

[#4]

@Jay_Warner , you are welcome