Dear all,

It should be an easy one.
I have a file called "c:\my documents\myfile.xls".
I need to find the file name proper without extenstions and path, i.e "myfile".
I am sure there is a function to do that, but forgot where to find it.

Any help?

Thanks in advance

Jonathan