Get Sheet Name
To return the sheet name in a cell, use CELL, FIND and MID in Excel. There’s no built-in function in Excel that can get the sheet name.
1. The CELL function below returns the complete path, workbook name and current worksheet name.
Note: instead of using A1, you can refer to any cell on the first worksheet to get the name of this worksheet.
2. Use the FIND function to find the position of the right bracket. Add 1 to return the start position of the sheet name.
3. To extract a substring, starting in the middle of a string, use the MID function. First argument (formula from step 1). Second argument (formula from step 2). Third argument (31).
Explanation: the MID function shown above starts at position 24 and extracts 31 characters (maximum length of a worksheet name).
4. To get the name of the second worksheet, simply refer to any cell on the second worksheet.
Next Chapter: Format Cells