If you can avoid using MS Word, do so. Nothing can fuck up text like a Microsoft application. I swear by
Textpad (you can get a trial). If you can export the excel file as CSV text, you can do the change case thing in Textpad, and then reimport the entries into a new Excel file.