Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@jkpieterse

jkpieterse/excel-lambda-SheetName.txt

Last active October 18, 2023 16:27
Show Gist options
  • Star 3 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jkpieterse/1541a4c51afa490958563fd7a9fdca0b to your computer and use it in GitHub Desktop.
Save jkpieterse/1541a4c51afa490958563fd7a9fdca0b to your computer and use it in GitHub Desktop.
Download ZIP
Excel lambda to get the name of the worksheet into a cell. Import this using the Excel Advanced Formula Environment add-in
Raw
excel-lambda-SheetName.txt
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