How to Format Text As All Capitals in Excel 2007

Converting the Lower-Case Text to Upper-Case Text
1. Open your workbook in Excel 2007.
2. Click in the cell immediately below the cell containing lower-case text.
3. Type, without the quotation marks, '=UPPER(' and click the cell containing the text you want to capitalize, then type ')' and then press 'Enter.'
Replacing the Lower-Case Text with Upper-Case Text
4. Click the cell containing the new capital letters to select it.
5. Right-click, then choose 'Copy.'
6. Click the cell containing the original lower-case text, right-click again, then choose 'Paste Special....' Under 'Paste,' choose 'Values,' then click 'OK.'