Return Cell Address (Without $)

[otrevino3]

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

 

[Aladin Akyurek]

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]

Cell Address w/o $ signs

Thanks!

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

 

[acw]

Hi

Try

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

Tony

 

[Aladin Akyurek]

Hi

Try

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

Tony

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

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

in mind.