Skip to content

Instantly share code, notes, and snippets.

@lukasmartinelli

lukasmartinelli/excel_formula.md

Last active February 16, 2017 13:16
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 lukasmartinelli/1320e220f82085db7399b0e622ae7b45 to your computer and use it in GitHub Desktop.
Save lukasmartinelli/1320e220f82085db7399b0e622ae7b45 to your computer and use it in GitHub Desktop.
Download ZIP
Excel Formula for Creating Filenames from Titles
Raw
excel_formula.md 
=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