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.

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


RSS Icon Subscribe to comments

You need to login to post a comment.