General discussion

  • Creator
    Topic
  • #2343781

    Excel / 1-2-3 Query

    Locked

    by andy1957 ·

    In Lotus 1-2-3, I used the @cell(“sheetname”,cell ref) function a lot.

    What is the equivalent function in Excel as there is no equivalent to the “sheetname” argument in Excel’s CELL function?

All Comments

  • Author
    Replies
    • #3707625

      Excel / 1-2-3 Query

      by dklippert ·

      In reply to Excel / 1-2-3 Query

      Cell, of course give the full path including the Sheet name (=Cell(“Filename”,A!)). To get just the file name, try this formula:
      =MID(CELL(“filename”,A1),FIND(“]”,CELL(“filename”,A1))+1,LEN(CELL(“filename”,A1))-FIND(“]”,CELL(“filename”,A1)))
      See http://www.cpearson.com/excel/excelF.htm
      There are some other formulas at the bottom of the page.

      • #3707524

        Excel / 1-2-3 Query

        by andy1957 ·

        In reply to Excel / 1-2-3 Query

        A quick answer like this is precisely why I use TechRepublic.

        Thanks for the web site address too. It looks very useful.

    • #3707523

      Excel / 1-2-3 Query

      by andy1957 ·

      In reply to Excel / 1-2-3 Query

      This question was closed by the author

Viewing 1 reply thread