Get row and column number inside cell in Excel using only formulas without macros

Question

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

So cell A1 will say (1,1), C2 will read (3, 2), etc. It will be a kind of self-referencing in some way.

Answer 1

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

Edit: Removed an unnecessary function call.

Answer 2

For cell self-binding use

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

Answer 3

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

=> (1,1)