rmeekers/Extract filename from URL in Google Sheets

Created April 4, 2019 17:29

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

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

Download ZIP

Raw

Extract filename from URL in Google Sheets

=TRIM(RIGHT(SUBSTITUTE(A2;"/";REPT(" ";100));99))

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