Using the CELL FUNCTION ~ Relative output required 1

[alchohaz]

Hi all

Hopefully a simple one for you

I am using the formula/function "CELL" as follows

=CELL("address",A1)

However it is returning and absolute ref "$a$1" when i need "a1" - please advise me how to implement

Thanks in advance
Al

 

[combo]

Process the text:
=SUBSTITUTE(CELL("address",A1),"$","")

combo

 

[alchohaz]

Combo - AWESOME, been looking all over the net for a fix

Next step for me is to increment the reference cells, and concentanate to create a more complex formula.

I have done it before but need to dig out - if you have a quick idea then great - please

Example
First cell will be A1 using your example, the next will be 7 columns along from here (H1), then another 8 etc etc.... Any ideas how to get that into a formula

Thanks for your help
Al

 

[combo]

You can find useful some of ROW, COLUMN, ADDRESS, OFFSET and INDIRECT functions.

combo

 

[alchohaz]

Hi Combo

Getting there - thanks for your help

=SUBSTITUTE(CELL("address",OFFSET(G106,0,3)),"$","")

Cheers
Al

 

[mintjulep]

I am reminded of:

=CELL("address",A1)

Why do you need a formula to return A1 when an input to the formula is A1?

You need 7 columns over, H1?

How about:

=CHAR(CODE("A")+7)&1

 

[SkipVought]

or
[tt]
=ADDRESS(1,8,4)
[/tt]



Skip,

_{Just traded in my old subtlety...
for a NUANCE!}