How to Make Lower Case Data All Caps in Excel 2007

1. Find the cell that contains the lower case information. Make note of the cell number. Cells in Excel are marked by a letter (column) and number (row). The first cell in a spreadsheet is A1.
2. Click in an empty adjacent cell where you want the upper case information to go. Formulas take existing data and change it based on the type of formula used. This information is then saved in its own separate cell where the formula was typed. Do not enter the formula in the cell that contains the lower case information. If you type the formula in the lower case cell, the words are deleted by the formula text.
3. Enter the formula '=UPPER(cell number)' into the cell. Use the cell number for the lowercase information. Do not enter the quotation marks.
4. Press the tab or enter button to exit the cell.