Forum Discussion

JG_Berson's avatar
JG_Berson
Copper Contributor
Oct 26, 2022
Solved

Cell reference substitution.

I'm trying to create a cell of text of same or another cells address. If I enter in cell C10 =cell("address",c10) I get as a result  $C$10  as expected.   But I need the result to be the text   C1...
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Nov 01, 2022

    JG_Berson

     

    =ROW(INDIRECT(B32)) returns the row number of the cell whose address is in B32.

    =COLUMN(INDIRECT(B32)) returns the column number of the cell whose address is in B32.

HansVogelaar's avatar
HansVogelaar
MVP
Oct 26, 2022

JG_Berson 

You can use

 

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

  • JG_Berson's avatar
    JG_Berson
    Copper Contributor
    Oct 26, 2022
    Thank you,
    I had actually tried that but must have had a typo. (old eyes!!!)
      • JG_Berson's avatar
        JG_Berson
        Copper Contributor
        Oct 27, 2022
        That only gives me C10 for any cell the formula is in. Not what I wanted.
        Thanks anyway.
        jgb

Resources