Formula for Cell address

[Elton Law]

Hi all,
Cell A1 contains a figure of 100.
Using formula =A1, it shows up 100. This is obvious.
Is there any way (formula) that it can give A1 (cell address) rather than
100 please ? Thanks

 

[Teethless mama]

Just type A1 instead of =A1

 

[Elton Law]

Hi,
Actually, I have 6550 row data to handle.
Typing all cells will certainly kill me.
So wanna have formula to represent the cell in absolute address.
Anyway, thanks for your response. But this does not help me.

 

[Glenn]

Hi all,
Cell A1 contains a figure of 100.
Using formula =A1, it shows up 100. This is obvious.
Is there any way (formula) that it can give A1 (cell address) rather than
100 please ? Thanks

Try the ADDRESS() function. Provide more details of what you are trying to
accomplish if you need more help.