Display file name without extension

[JET2011]

I simply want to show the file name in a cell, preferably without the extension.

I am using MS Professional 2010 and Excel ver 14


Thanks

[Tony Valko]

The file must already exist (in other words, it has been saved and given a name).

Entered in any cell...

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

[JET2011]

It works! Thanks Tony - amazing how complicated but glad didn't need programing.

[Tony Valko]

You're welcome. Thanks for the feedback!


If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.