MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Remove the pathname


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

Hi,
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.

=MID(A1,FIND(CHAR(13),SUBSTITUTE(A1,"\",CHAR(13),LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))))+1,255)

Aladin

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

Thank you very much!