Cell address without absolute reference

J

jayray

I am using =CELL("address",A1) and I get "$A$1" as the text string.
How do I get just "A1", without the absolute $ signs?

Thanks.
 
Top