Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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

jkpieterse commented Feb 23, 2022

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