Convert text case in cells to uppercase, lowercase, or other capitalizations
![How to change text case in Excel with XLTools add-in](/static/c89e66584c4065e08490a0d68dfa839d/ff57f/xltools-change-text-case-in-excel.png)
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.
![Get started with XLTools ribbon](/static/75ac5fb276b36f709bde811d2e2a22c1/24bc3/xltools-ribbon-overview.png)
Download XLTools for Excel
How to change all text cells to sentence case
- Select the range where you want to change text capitalization.
- 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 convert text in Excel to sentence case letters](/static/b9da3a6a1c451f798a815e1e49a33035/2ae73/excel-convert-to-sentence-case.png)
How to change all text cells to lowercase
- Select the range where you want to change text capitalization.
- 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 convert text in Excel to lowercase letters](/static/95e2921a1fee45e4c4d48a870d4e71e1/78fc7/excel-convert-to-lowercase.png)
How to change all text cells to uppercase
- Select the range where you want to change text capitalization.
- 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 convert text in Excel to uppercase letters](/static/f244bff2c24721f675447f997a73ce65/78fc7/excel-convert-to-uppercase.png)
How to capitalize each word in all text cells
- Select the range where you want to change text capitalization.
- 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.
![How to convert text in Excel to proper case](/static/f9cfcbe42beed77823d90bad2072d22f/2ae73/excel-capitalize-each-word.png)
Any questions or suggestions?