Formula for Cell address

  • Thread starter Thread starter Elton Law
  • Start date Start date
E

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
 
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.
 
Elton said:
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
Click to expand...


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