Get workbook name only

An excel formula to get workbook name only

Related Functions

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]", CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)

If you want to get the workbook name only (i.e. the file name without path or sheet name) you can do so with a rather long formula that uses the MID function along with the FIND function. The final result will look something like this:


How the formula works

The cell function is used to get the full file name and path:


The result looks like this:


At the highest level, the MID function simply extracts the file name from the path and sheet. The starting position is calculated with FIND:


The number of characters to extract is also calculated with FIND:


0 votes. 0 / 5