Hi Wesley

=CELL("Address") will return $A$1
If you don't want the $ signs, you could use
=SUBSTITUTE(CELL("Address"),"$","") to return A1

--
Regards

Roger Govier


"wesley" wrote in message
...
is there any way to display the row and column number in cell.

A B
1 test
2
3
--------------------------------
A B
1 A1
2
3

thank you for your help