How to change case of text in Excel?
Excel offers several intuitive methods for changing the case of text within your worksheets, simplifying data cleaning and presentation. Whether you need to standardize data entry or prepare text for reports, mastering these tools can greatly enhance your spreadsheet skills. This article explores different approaches to modifying text case in Excel using both built-in functions and advanced tools like Kutools for Excel.
Change case of text with Excel Functions
Quickly change case of text with Kutools for Excel
Change case of text with Excel Functions
Excel provides three essential functions to modify text case directly in your worksheets:
LOWER: Converts all text to lowercase (e.g., "EXCEL" becomes "excel").
UPPER: Transforms all text to uppercase (e.g., "excel" becomes "EXCEL").
PROPER: Capitalizes the first letter of each word and sets all others to lowercase (e.g., "i am jay" becomes "I Am Jay").
Suppose you have text that needs case conversion. For example, to change text to lowercase:
To change all the text case to lower case, please do as follows:
1. In an adjacent blank cell, such as cell C1, type the formula below, press the Enter key.
=LOWER(A1)
2. Select cell C1 and drag the fill handle to apply this formula to other cells as needed. The text will convert to lowercase as you extend the formula.
3. Since these are formulas, remember to paste them as values if copying to another location.
- To change all the text case to upper case, please enter this formula below.
= UPPER(A1)=PROPER(A1)Using the Excel functions to change text case may seem a little complicated, but with Kutools for Excel’s Change Case utility, there are more functions you can use to change the text case.
Quickly change case of text with Kutools for Excel
For those seeking a more straightforward and feature-rich option, Kutools for Excel's Change Case utility offers enhanced flexibility and functionality. This tool allows you to not only switch between upper, lower, and proper cases but also provides options for toggle case and sentence case, accommodating virtually any text formatting need.
- Change any text case to upper case;
- Change any text case to lower case;
- Change any text case to proper case;
- Toggle text case;
- Change any text case to sentence case;
- Sentence case: the first word in every sentence is capitalized, and all other letters will be converted to lower case. Sentences are deemed to start after full stops, exclamation marks, colons, and question marks (. ! : ?) (For example: I AM JAY. > I am jay.).
- tOGGLE cASE: all UPPERCASE characters are converted to lowercase and vice-versa (for example: eXCeL > ExcEl).
1. Select the cells whose text case you want to change.
2. Click "Kutools" > "Text" > "Change Case", see screenshot:
3. In the "Change Case" dialog box, specify the type of text case you want to be changed from "Change type" option, at the same time, you can preview the results from the "Preview" Pane. See screenshot:
4. Then click "OK" or "Apply" button. And the text case of the selected cells has been converted to the case type as you need. (click OK button will close the dialog box and apply the operation; but click Apply button will only apply the operation without closing the dialog box)
- To use this feature, you should install Kutools for Excel first, please click to download Kutools for Excel now.
- To know more about this feature, please view our Change Case tutorial.
Related articles:
- Change text strings to sentence case
- Change text strings to uppercases
- Change uppercase to lowercase
- Change uppercase to proper or title case
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite — Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license — set up in minutes (MSI-ready)
- Works better together — streamlined productivity across Office apps
- 30-day full-featured trial — no registration, no credit card
- Best value — save vs buying individual add-in