Get the row and column number from within a cell in Excel using only formulas without macros

Question

Is there a way to get the row and column of any given cell by inserting a formula into that cell?

So cell A1 would say (1,1), C2 would read (3, 2), etc. This would be kind of a self reference in a way.

Answer 1

To self reference a cell, use

=CONCATENATE("(",COLUMN(), ", ",ROW(),")")

Answer 2

=CONCATENATE("(",COLUMN(A1), ", ",ROW(A1),")")

Edit: Removed unnecessary function call.