Advanced Search

Excel function to extract a filename from a fullpath

/ Published in: Other
Save to your folder(s)
This script will also work on any spreadsheet program like Google Docs.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. =MID(B1,FIND("*",SUBSTITUTE(B1,"\","*",LEN(B1)-LEN(SUBSTITUTE(B1,"\",""))))+1,LEN(B1))

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.