Display row & column number in cell

[wesley]

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

 

[Roger Govier]

Hi Wesley

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

 

[Max]

Put in A1: =ADDRESS(ROW(),COLUMN(),4)
Above returns A1. Just copy across & fill as required.

 

[wesley]

thank you both of you guy, I get it !

 

[Max]

You're welcome !