I've got a folder with about 4000 images in it. The images are portraits and are named with the person's id number. I also have a spreadsheet with the id numbers and people's names in separate columns. I'd like to update the filenames from 123-123-4567 to John-Smith_123-123-4567.
I found this answer
which is similar, but not quite what I'm after.
Any excel wizards want to tackle this? :)