You can easily get the current worksheet name in an Excel spreadsheet. Do you want to know how to do that? then this article will help you to understand the instructions to complete the task. You can use a combination of the MID function, CELL function, and FIND function. Let’s get into this article.
Get the Current Worksheet Name:
To get the current spreadsheet name, we have to use three functions such as MID, CELL and FIND functions.
- MID Function – It extracts the number (starting from the left side) or characters from the given string.
- CELL Function – The Excel CELL function returns information about a cell in a worksheet. The type of information to be returned is specified as info type.
- FIND Function – This function will find out the location of the text and returns the position as a number.
Use the below formula to get the current Worksheet name:
=MID(CELL(“filename”,B1),FIND(“]”,CELL(“filename”,B1))+1,255)
- You need to open the workbook.
- Then apply the formula in any cell. Here, we have shown the formula in Cell B5.
- After applying the formula, you will get the result as shown in the below screenshot.
Verdict:
In the above article, you can clearly learn the instructions to get the current worksheet name in an Excel spreadsheet using MID, CELL, and FIND functions. We have shown you an example for your quick reference, so it might be helpful to you. Leave your feedback in the below comment box. Thanks for visiting Geek Excel!! Keep Learning!!
Top comments (0)