Excel-Change Uppercase to Proper Case

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).

ExcelUpper2Proper-6

*Logon to Atomic Learning with your network username and password.

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS
Posted in Computer Tips, Home Page

Subscribe to the ITS Blog Now