Formula to find filename

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to find filename 2
SaveFileDialog + FileName 8
FileName and Path Not Changing 2
Auto Text not updating in Word 2003 5
Can I use a worsheet name (filename), and a range name as values? 2
Streaming a word doc to the browser... 2
How to get a network path from a file 1
copy files from one dir to another 7

Back
Top