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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referencing cells in consecutive rows 2
Excel does not accept text format! 0
Absolute position in Layout 2
Merging from an Excel file with graphics 1
absolute reference fill 1
Using icon sets with relative references 0
VBA for Dependents shortcut menu 0
Perplexed by simple Icon Set Cond. Formatting Issue 0

Top