atadams/gist:1200918

Created September 7, 2011 15:40

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/atadams/1200918.js"></script>
Save atadams/1200918 to your computer and use it in GitHub Desktop.

Download ZIP

Excel Formula: Extract file name from path

Raw

gistfile1.txt

=MID([path],FIND("*",SUBSTITUTE([path],"/","*",LEN([path])-LEN(SUBSTITUTE([path],"/",""))))+1,LEN([path]))

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment