Workbook And Sheet Name With Aormula

less than 1 minute read

These formulas require that the workbook is saved

Get the file name of this workbook:

Formula: =CELL("filename",A1)
Result: C:[MyWorkbook.xlsx]Sheet1

Get the file name of this workbook without the file extension:

Formula: =MID(CELL("filename",A1),SEARCH("[",CELL("filename",A1))+1,SEARCH(".",CELL("filename",A1))-1-SEARCH("[",CELL("filename",A1)))
Result: MyWorkbook

Get the active sheet name:

Formula: =RIGHT(CELL("Filename",A1),LEN(CELL("Filename",A1))-FIND("]",CELL("Filename",A1)))
Result: Sheet1

Reference another sheet name:

Formula: ="'"&MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)&"'!"
Result: ‘Sheet1!

Categories: formulas

Updated: September 27, 2018

Twitter Facebook LinkedIn

Leave a Comment