Microsoft Excel 2007 - Globally Changing all UPPERCASE to Proper Case
Posted on 2013-01-29
I have a spreadsheet where everything is in upper case. All of the columns and their content are all UPPER CASE.
I've seen some google "solution" for changing them to ProperCase, but it requires inserting new columns for each column to have a formula applied to it.
I would like a Formula or a Visual Basic script to globally change all columns in the spreadsheet to Proper Case.
Is this possible? Windows Excel 2007.