I was going to suggest a manual way first, but it could quickly get old. If you have to do it more than a handful of times, then it would make sense to automate. In the case of manual, I would choose notepad++ over a spreadsheet program though.