Where is Excel's FILENAME(path) string function?

[baobob]

Where is Excel's function to return the filename string given the full
path string?

I.e., given "C:\MyDir\MyFile.xls", return "MyFile.xls".

Thanks.

***

 

[baobob]

P.S. The path I gave was a bad example. It may suggest I want to know
how to query the current workbook name. I don't.

I want to know what function can parse the filename (or the path
prefix) out of ANY path string.

Thanks.

***

 

[Pete_UK]

Take a look here:

http://www.xldynamic.com/source/xld.xlFAQ0002.html

Hope this helps.

Pete