View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
roadkill roadkill is offline
external usenet poster
 
Posts: 173
Default 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