ExcelBanter - sheet name

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sheet name (https://www.excelbanter.com/excel-discussion-misc-queries/178652-sheet-name.html)

Petros[_2_]

sheet name

Hi!
Is there a function that gives me the name of the sheet in a cell?
Thank you

Gary''s Student

sheet name

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99)
--
Gary''s Student - gsnu200771

All times are GMT +1. The time now is 02:12 AM.