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)

 

Resources