Skip to content

Instantly share code, notes, and snippets.

@lukasmartinelli
Last active February 16, 2017 13:16
Show Gist options
  • Save lukasmartinelli/1320e220f82085db7399b0e622ae7b45 to your computer and use it in GitHub Desktop.
Save lukasmartinelli/1320e220f82085db7399b0e622ae7b45 to your computer and use it in GitHub Desktop.
Excel Formula for Creating Filenames from Titles
=CONCATENATE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(D11)," ","-"),"-","_"),"ä","ae"), "(", "_"), "(", "_"), "ö", "oe"), ",", "_"), "/", "_"), "__", "_"), ".csv")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment