Skip to content

Instantly share code, notes, and snippets.

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))))
Copy link

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:

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