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