Posted By

pollusb on 03/10/09


Tagged

excel


Versions (?)

Excel function to extract a filename from a fullpath


 / Published in: Other
 

This script will also work on any spreadsheet program like Google Docs.

  1. =MID(B1,FIND("*",SUBSTITUTE(B1,"\","*",LEN(B1)-LEN(SUBSTITUTE(B1,"\",""))))+1,LEN(B1))

Report this snippet  

You need to login to post a comment.