=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