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

B

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.

***
 
B

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.

***
 
Top