Change case

The Power-user add-in helps you clean your Excel data by easily transforming the case of your text:

• From the Power-user tab in Excel, click the Change Case menu. 
• In the menu, click one of the following options:
  • Sentence case: this will add an upper letter at the beginning of each sentence, while keeping everything else in lower case. This is the option that will be applied by default.
  • Upper case: this will convert all text to capital letters.
  • Lower case: this will convert all text to small letters.
  • Proper case: this will convert the first letter of each word to a capital letter, while changing everything else to small letters.
  • Toggle case: this will invert the existing case of each letter.
• A selection dialog box opens. Select the Excel range to clean and click OK.