19. Excel Tips - Function to return the worksheet name | ExcelExperts.com

There isn't a single function to return the sheet name, but you can use a combination of functions to get at it. =RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename"),1)) - Here's a breakdown of what it's doing: Sheet Name example Traini

excelexperts.com