Formula to find filename
 

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
--
Kevin

Formula to find filename
 

=CELL("filename",A1)


"Kevin" wrote:

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
--
Kevin

Formula to find filename
 

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"
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

Formula to find filename
 

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
--
Kevin


"tiptoe" wrote:

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"
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