lukasmartinelli/excel_formula.md

Last active February 16, 2017 13:16

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

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

Excel Formula for Creating Filenames from Titles

Raw

    =CONCATENATE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(D11)," ","-"),"-","_"),"ä","ae"), "(", "_"), "(", "_"), "ö", "oe"), ",", "_"), "/", "_"), "__", "_"), ".csv")