Formula to find filename

[Guest]

Hi

I have a file path, say
C:\MY Files\Media\Test.doc

I am sure there is a excel cell formula which can return the name of the
file (ie "Test.doc") no matter how many directories or the lenght of the
address

any ideas

thanks

 

[Guest]

=CELL("filename",A1)

 

[tiptoe]

see bottom of the page of this reference - http://www.cpearson.com/excel/excelF.htm

May be what you are looking for.

This will return "MyBook.xls"

 

[Guest]

what if the formula is reading a filepath in another cell ie I do not want
the file name of the existing file the formula is written in