Forum Discussion

aaghd's avatar
aaghd
Copper Contributor
Dec 15, 2023

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)

     

aaghd's avatar
aaghd
Copper Contributor
I have pasted this in the cell where I want the value and I am getting an #Value! I did take out all spaces in the formula you wrote. Please let me know if I have done something wrong. The name on the sheet is "X Borough". Thanks.
Patrick2788's avatar
Patrick2788
Silver Contributor
Dec 15, 2023

aaghd 

If you're using Excel for web you'll get a #VALUE! error:

CELL is not available in the web app.

  • aaghd's avatar
    aaghd
    Copper Contributor
    Dec 15, 2023
    I must be using the Web. So thanks for helping. I appreciate you. Happy Holidays.

Resources