Last active
October 18, 2023 16:27
-
-
Save jkpieterse/1541a4c51afa490958563fd7a9fdca0b to your computer and use it in GitHub Desktop.
Excel lambda to get the name of the worksheet into a cell. Import this using the Excel Advanced Formula Environment add-in
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SheetName =LAMBDA(cl,LET(f,CELL("filename",cl),MID(f,FIND("]",f)+1,LEN(f)))) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
After importing this Excel-Lambda Gist, you can use this Excel formula in any sheet to get the name of that sheet:
=SheetName(A1)