This is for a few (including Nancy) who have been needing the Change Case to work for everything in Excel, like McRitchie, as Proper, Upper and Lower don't always cut it. This is found on Dave McRitchie's page, at the following link:

http://www.mvps.org/dmcritchie/excel/proper.htm