ExcelBanter - Workbook Name Edited in Cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Workbook Name Edited in Cell (https://www.excelbanter.com/excel-worksheet-functions/201521-workbook-name-edited-cell.html)

roadkill

Workbook Name Edited in Cell

Good day,

I have this:
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)

But how can I get the name of the Workbook in a cell minus the ".xls" at the
end?

Thank you

roadkill

Workbook Name Edited in Cell

Never mind, got it now. Thanks

"RoadKill" wrote:

Good day,

I have this:
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)

But how can I get the name of the Workbook in a cell minus the ".xls" at the
end?

Thank you

All times are GMT +1. The time now is 02:35 PM.