Friday, April 15, 2011

How to Change Text Case in Microsoft Excel


How to Change Text Case in Excel 2007
1. Open the Excel spreadsheet.
2. Click on the cell that is next to the first data cell in the row of cells to be changed.
3. Type in =Lower (cell#) to change the text to lower case. Type in =Upper(cell#) to change the text to upper case. Type in =Proper(cell#) to change the text to proper case.Example: In cell B6 type in: =Proper(A6) to change the text in the A column to proper case.
4. Click 'Home' and then 'Fill>Down,' or click and drag down the row of adjacent cells to fill them with the text-case formula. The row should now contain the new text version of the original row of cells.
5. Click on the top cell of the newly filled row and drag down to highlight the entire row.
6. Click 'Home>Copy.'
7. Click on the first cell of the row containing the original data.
8. Click 'Paste>Paste Special>Values>OK.' The data with the new text case will appear in the original data row.
9. Delete the row adjacent to the data. Click 'Save' to save the changes you made to the spreadsheet.
How to Change Text Case in Older Versions of Excel
10. Open the Excel spreadsheet.
11. Click on the cell that is next to the first data cell in the row of cells to be changed.
12. Click 'Insert>Columns.'
13. Click on the first cell in the newly inserted column that is next to the first original data cell.
14. Type in =Lower (cell#) to change the text to lower case. Type in =Upper(cell#) to change the text to upper case. Type in =Proper(cell#) to change the text to proper case.Example: In cell B6, type in: =Proper(A6) to change the text in the A column to proper case.
15. Click on that cell again and drag down the row of adjacent cells to highlight the row.
16. Click 'Edit>Fill>Down.' Click 'Copy.'
17. Click on the first cell in the row containing the original data.
18. Click 'Edit>Paste Special>Values>OK.' The data with the new text case will appear in the original data row.
19. Delete the row adjacent to the data. Click 'Save' to save the changes you made to the spreadsheet.

Blogger news