Skip to content

Instantly share code, notes, and snippets.

@rmeekers

rmeekers/Extract filename from URL in Google Sheets

Created April 4, 2019 17:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rmeekers/9d4b6d8dfd448cd9f0ddaeaf6314fbc9 to your computer and use it in GitHub Desktop.
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