Friday, May 25, 2012

How to Change the Case in Excel 2007


1. Open Excel 2007 and select a workbook that contains data that needs the case changed. Click the 'Office' button and select 'Open.' Browse your computer and locate the workbook. Click the workbook and select 'Open.'
2. Insert a column near the data. Click on the first cell in the column. Click on the 'Formulas' tab in the ribbon. Select the 'Text' option. Click 'Proper.' The Function Arguments window opens. Click on the red box in this window. Highlight the first cell that needs the case changed. The cell reference appears in the Function Arguments window. Click 'OK.'
3. Review the results of the Proper function. The case of the data has been changed to proper case. The first letter of each word is now capitalized.

Blogger news