Return Cell Address (Without $)

otrevino3

New Member
Joined
Jan 25, 2005
Messages
22
Hello.

I've got this formula in cell A2, and it returns "$A$2" (without quotes).

=ADDRESS(ROW(),COLUMN())

How can I tweak the formula to return "A2" (without the dollar signs and quotes)?

thx
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
otrevino3 said:
Hello.

I've got this formula in cell A2, and it returns "$A$2" (without quotes).

=ADDRESS(ROW(),COLUMN())

How can I tweak the formula to return "A2" (without the dollar signs and quotes)?

thx

=ADDRESS(ROW(),COLUMN(),4)

But, what for?
 

otrevino3

New Member
Joined
Jan 25, 2005
Messages
22
Cell Address w/o $ signs

Thanks! :)

I just need a column of cells that will serve as an index.
 

acw

MrExcel MVP
Joined
Feb 13, 2004
Messages
4,814
Hi

Try

Code:
=substitute(ADDRESS(ROW(),COLUMN()),"$","")


Tony
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
acw said:
Hi

Try

Code:
=substitute(ADDRESS(ROW(),COLUMN()),"$","")


Tony

That means one more function. Maybe you had something like this

=SUBSTITUTE(CELL("address",A2),"$","")

in mind.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,069
Messages
5,570,013
Members
412,304
Latest member
citrus
Top