If a column of names is in all UPPER case but you need it in Proper case, instead of retyping everything, add a column, and then in the new column, write a function that changes the data.
The function is =PROPER(cell address).
- ITS Knowledgebase Article: Change Uppercase to Proper Case
- Atomic Learning*: Mastering Excel 2013 Text Functions (Starts @ 5:10)
*Logon to Atomic Learning with your network username and password.