Display row & column number in cell
 

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

Display row & column number in cell
 

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

Display row & column number in cell
 

Put in A1: =ADDRESS(ROW(),COLUMN(),4)
Above returns A1. Just copy across & fill as required.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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

Display row & column number in cell
 

thank you both of you guy, I get it !

"wesley" wrote:

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

Display row & column number in cell
 

You're welcome !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"wesley" wrote in message
...
thank you both of you guys, I get it !