Forum Discussion

Jay_Warner's avatar
Jay_Warner
Copper Contributor
Mar 28, 2020
Solved

How to convert a cell address to text?

Each cell has an address, such as DA2 [Col DA, row 2].  How can I convert this to a text, such as "DA2", that I can then put into another cell [preceded with a ' to keep it a text] to indicate the location of the first cell?

Excel on Mac

5 Replies

  • Custom_Covers_Ltd's avatar
    Custom_Covers_Ltd
    Copper Contributor
    Dec 05, 2024

    Hi guys!

    Very useful info here! Thanks a lot! I have the following issue:

    The cell A1 from Sheet1 refers to cell with address Sheet2!$k$2. What formula should be used if I need to put in B1 from Sheet1 the following: Sheet3!$k$2

    I just need to refer to the same absolute address $k$2 (or whatever is written in A1), but in another sheet - for example Sheet3, Sheet4 etc.?
    Thanks a lot for your help!

    JJ

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Dec 05, 2024

      If the sheets are really named Sheet2, Sheet3, Sheet4 etc., enter the following formula in A1 on Sheet1:

      =INDIRECT("Sheet"&COLUMN()+1&"!K2")

      Then fill to the right.

Resources