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

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" <(E-Mail Removed)> wrote in message
news:3D0E0687-922F-40C1-A567-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
news:3D0E0687-922F-40C1-A567-(E-Mail Removed)...
> 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

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

You're welcome !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"wesley" <(E-Mail Removed)> wrote in message
news:03A5F898-E480-41D3-9024-(E-Mail Removed)...
> thank you both of you guys, I get it !