Change case

Modified on Wed, 19 Oct, 2022 at 5:43 PM

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.

Power-user add-in l Change text case in Excel

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article