Convert text case in cells to uppercase, lowercase, or other capitalizations

How much time do you spend fixing text case in Excel cells? Inconsistent text case can cause problems with sorting, filtering, and calculations. Converting text capitalization manually or using formulas is not a productive option, especially when you work with large spreadsheets.

The Change Text Case feature helps unify capitalization in a data set in seconds:

  • Sentence case
  • lowercase
  • UPPERCASE
  • Capitalize Each Word

Before you begin, add Change Text Case to Excel

Change Text Case is one of the 20+ features within XLTools Add-in for Excel. Works in Excel 2019, 2016, 2013, 2010, desktop Office 365.

– free trial gives you 14 days of full access to all features.

How to change all text cells to sentence case

  1. Select the range where you want to change text capitalization.
  2. Click the Text Case button on XLTools ribbon Select Sentence case from the drop-down list Done, text case is unified throughout the range.

How to change all text cells to lowercase

  1. Select the range where you want to change text capitalization.
  2. Click the Text Case button on XLTools ribbon Select lowercase from the drop-down list Done, text case is unified throughout the range.

How to change all text cells to uppercase

  1. Select the range where you want to change text capitalization.
  2. Click the Text Case button on XLTools ribbon Select UPPERCASE from the drop-down list Done, text case is unified throughout the range.

How to capitalize each word in all text cells

  1. Select the range where you want to change text capitalization.
  2. Click the Text Case button on XLTools ribbon Select Capitalize Each Word from the drop-down list Done, text case is unified throughout the range.
Any questions or suggestions?
How can we help?