| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell address without absolute reference
=SUBSTITUTE(CELL("address",A1),"$","")
-- David Biddulph "jayray" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I avoid excel change absolute address to relative address | Excel Discussion (Misc queries) | |||
| what is difference between absolute address and relative address? | Excel Discussion (Misc queries) | |||
| absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
| Absolute Cell Reference | Excel Discussion (Misc queries) | |||
| How do you select a cell with an "absolute" address with a cursor? | New Users to Excel | |||
Linear Mode
