Posted by askmatt
May 10th, 2011 
No Comments
Excel rename images and prepend directory name
Excel function to modify image filenames, it converts to all lower case, replaces spaces with hyphens and prepends a directory name to the string.
“brands” is the directory that is added.
“G2″ contains the original filename.
=CONCATENATE("brands/",LOWER(SUBSTITUTE(G2," ","-")))
