MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Remove the pathname

Posted by A on February 08, 2001 5:44 PM

How to remove the pathname of a file. For example, how to remove C:\desktop\newfolder\ to a.xls from the path C:\desktop\newfolder\a.xls Thank You!

Posted by Aladin Akyurek on February 08, 2001 10:12 PM

The formula that follows is due to Bob Umlas.



Posted by A on February 11, 2001 11:21 PM

Thank you very much!