Skip to content

Instantly share code, notes, and snippets.

@jkpieterse
Last active October 18, 2023 16:27
Show Gist options
  • Save jkpieterse/1541a4c51afa490958563fd7a9fdca0b to your computer and use it in GitHub Desktop.
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
SheetName =LAMBDA(cl,LET(f,CELL("filename",cl),MID(f,FIND("]",f)+1,LEN(f))))
@jkpieterse
Copy link
Author

After importing this Excel-Lambda Gist, you can use this Excel formula in any sheet to get the name of that sheet:
=SheetName(A1)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment