Retrieving and Entering the Sheet Name in a Cell

[aaghd]

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 displayed in one of the sheet cells.

Thanks,

[#2]

@aaghd 

If you're in Excel 365, you can use:

=LET(filename, CELL("filename"), TEXTAFTER(filename, "]", -1))

[#3]

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.

[#4]

@aaghd 

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

CELL is not available in the web app.

[#5]

I must be using the Web. So thanks for helping. I appreciate you. Happy Holidays.

[#6 · Accepted solution]

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)

[#7]

@Rodrigo_ 

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

[#8]

You're welcome buddy

[#9]

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?