File name only in cell?

**benh** · 09-08-2009, 09:32 AM

Is it possible to set a cell equal the the file name of the Excel file?

I know you can set it equal to the full path but I want the file name only!

Thanks, Ben

**sweep** · 09-08-2009, 09:35 AM

Try this:

=MID(CELL("FILENAME",F10),FIND("[",CELL("FILENAME",F10))+1,FIND("]",CELL("FILENAME",F10))-FIND("[",CELL("FILENAME",F10))-1)

**benh** · 09-08-2009, 09:43 AM

Wow........thanks Dave.

Is it possible to get rid of the '.xls' too?

Cheers, Ben

**sweep** · 09-08-2009, 10:05 AM

Yes,

but this will only work for .xls files - not .xlsx or .xlsm

=SUBSTITUTE(MID(CELL("FILENAME",F10),FIND("[",CELL("FILENAME",F10))+1,FIND("]",CELL("FILENAME",F10))-FIND("[",CELL("FILENAME",F10))-1),".xls","")