Forum Discussion

aaghd's avatar
aaghd
Copper Contributor
Dec 15, 2023
Solved

Retrieving and Entering the Sheet Name in a Cell

Help says that you can retrieve a sheet name but does not clearly explain the syntax necessary to do so.  I can get it to bring the number of the sheet, but I would like the "Name" of the sheet displ...
excel
  • Rodrigo_'s avatar
    Rodrigo_
    Dec 16, 2023

    Hello aaghd,
    you can use this formula to show the sheet name on a certain cell,

    =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

     

Rodrigo_'s avatar
Rodrigo_
Iron Contributor
Dec 16, 2023

Hello aaghd,
you can use this formula to show the sheet name on a certain cell,

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

 

aaghd's avatar
aaghd
Copper Contributor
Dec 19, 2023

Rodrigo_ 

 

Thank you for the formula.  It works perfectly.  Your time and attention to my question is greatly appreciated.  Happy Holidays to you!

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Dec 20, 2023
    That's interesting that the legacy approach to showing the sheet name works. Both solutions use CELL which is not available in Excel web app. Which version are you using?
  • Rodrigo_'s avatar
    Rodrigo_
    Iron Contributor
    Dec 20, 2023
    You're welcome buddy

Resources