Forum Discussion
Solved
workbook and sheet name via formula
I have a standard header I put on almost every excel workbook I create I have been using for years. It includes several standard items, including Workbook name and Worksheet name, which are extracted...
Afraid for Excel Online that's only with Office Script, there are properties getName both for workbook and worksheet.
VBA and related functions don't work in Excel Online.
Just in case anyone else was after a formula using standard excel functions to copy paste and get the sheet name: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1))+1)
An alternative to fetch sheet name (365, desktop version only):
=TEXTAFTER(CELL("filename"),"]")
Wow Patrick, very elegant. However that doesn't work in Excel in SharePoint.