Thread: Cell address without absolute reference
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jayray jayray is offline
external usenet poster
  
Posts: 45
Default Cell address without absolute reference
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.
Reply With QuoteReply With Quote