When large amounts of data get dumped into an Excel 2010 file, correcting the formatting one cell at a time can be an arduous task. While Excel doesn't have a direct command to only capitalize the first letter in a cell, you can combine a number of Excel functions to get your required capitalization in an adjacent cell. Then, you just have to copy over the original information with your new, correctly capitalized information.
Instructions
1. Open the Excel 2010 file that contains the text that you want to capitalize.
2. Right-click on the column letter directly above the first cell that contains your text. Choose "Insert" from the pop-up menu and a new column will appear to the left of your selected column.
3. Click on the cell directly to the left of the first cell that holds your text.
4. Enter the following formula into the cell: =upper(left(XX,1))&right(XX,LEN(XX)-1) where "XX" is the column letter followed by the row number of the cell to the right of the current one. Press "Enter" when you are finished entering the formula and you should see your text repeated in the formula cell, except with the first letter capitalized.
5. Click the cell where you entered your formula and press "Ctrl" and "C" to copy the formula to the clipboard. Paste the formula, using "Ctrl" and "V", to an empty cell to the left of any text you want to capitalize this way. You may need to insert additional columns to get an empty cell to the left of your text.
6. Right-click the cell with your formula and choose "Copy" from the list of options. Even if you already have this cell in the clipboard, it is better to be sure that you are copying the correct cell.
7. Right-click on the cell with the original text. Move your mouse over "Paste Special" in the pop-up menu and choose "Paste Values." Repeat this for any other cells that you are capitalizing.
8. Right-click on the letter above the column you created earlier in the process. Choose "Delete" from the menu to remove the column, leaving you with just the capitalized text. Repeat this for any other columns you created.
