Workbook Name Edited in Cell

[RoadKill]

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]

Never mind, got it now. Thanks