Unlike Microsoft Word, Microsoft Excel doesn't have a Change Case button for changing capitalization. However, you can use the UPPER, LOWER, or PROPER functions to automatically change the case of existing text to uppercase, lowercase, or proper case. Functions are just built-in formulas that are designed to accomplish specific tasks—in this case, converting text case.
Feb 24, 2016 - You can change the case of selected text in a document by clicking a. Unlike Microsoft Word, Microsoft Excel doesn't have a Change Case. Unlike Word, Excel does not have a change case facility. However you can use this method So what do you do if you have a column of Names all typed in CAPITAL LETTERS?Microsoft Excel has some handy functions to change case - this is what you can do: 1.
How to Change Case
In the example below, the PROPER function is used to convert the uppercase names in column A to proper case, which capitalizes only the first letter in each name.
- First, insert a temporary column next to the column that contains the text you want to convert. In this case, we’ve added a new column (B) to the right of the Customer Name column.
In cell B2, type =PROPER(A2), then press Enter.
This formula converts the name in cell A2 from uppercase to proper case. To convert the text to lowercase, type =LOWER(A2) instead. Use =UPPER(A2) in cases where you need to convert text to uppercase, replacing A2 with the appropriate cell reference. - Now, fill down the formula in the new column. The quickest way to do this is by selecting cell B2, and then double-clicking the small black square that appears in the lower-right corner of the cell.Tip: If your data is in an Excel table, a calculated column is automatically created with values filled down for you when you enter the formula.
- At this point, the values in the new column (B) should be selected. Press CTRL+C to copy them to the Clipboard.
Right-click cell A2, click Paste, and then click Values. This step enables you to paste just the names and not the underlying formulas, which you don’t need to keep. - You can then delete column (B), since it is no longer needed.
Need more help?
You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.
See Also
How to change case of text in Excel?
This article is going to talk about the methods you can apply for changing text case easily in Excel.
Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel - The Best Office Productivity Tool Will Solve Most of Your Excel Problems
- Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
- More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words...
- Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum...
- Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns...
- Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Create Mailing List and Send Emails by Cell's Value...
- Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
- More than300 powerful features; Works with Office2007-2019 and 365; Supports all languages; Easy deploying in company; Full features60-day free trial.
Change case of text with Excel Functions
Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari!
Save 50% of your time, and reduce thousands of mouse clicks for you every day!
Microsoft Excel provides following three worksheet functions for changing text case:
LOWER case: Converts all uppercase letters in a text string to lowercase.
UPPER case: Converts all lowercase letters in a text string to uppercase.
PROPER case: Capitalizes the first letter in a text string and converts all other letters to lowercase letters (For example, i am jay > I Am Jay).
Supposing you need to change the case of following existing text in a worksheet:
To change all the text case to lower case, please do as follows:
1. In an adjacent blank cell, such as cell C1, type this formula =LOWER(A1). See screenshot:
2. Then press Enter key, and select cell C1, and then drag the fill handle over to the cell that you want to contain this formula. And all the text case has been converted to lower case. See screenshot:
3. As they are formulas, when you copy them to other place, please paste them as values.
Notes: 1. To change all the text case to upper case, please enter this formula = UPPER(A1).
2. To change all the text case to proper case, please enter this formula =PROPER(A1).
To use the Excel functions for changing text case may be a little bit complicated, but with Kutools for Excel’s Change Case utility, there are more functions you can use to change the text case.
Change case of text with Kutools for Excel
You can easily change text case with Change Case tool of Kutools for Excel, with this tool, you can do following options:
- Change any text case to upper case;
- Change any text case to lower case;
- Change any text case to proper case;
- Change any text case to tOGGLE 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).
Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. Get it Now.
After installing Kutools for Excel, please apply this utility with following steps:
1. Select the range cells that you want to change the case.
2. Click Kutools > Text Tools > 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 know more about this feature, please click Change Case.
Related articles:
Kutools for Excel - The Best Office Productivity Tool Increase Your Productivity by80%
- Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
- Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
- Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
- Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
- Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
- Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
- Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
- More than300 powerful features. Supports Office/Excel2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features60-day free trial.
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 by50%, and reduces hundreds of mouse clicks for you every day!
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
- This really irritates me. Maybe someone can suggest a solution, I didn't find it here.
Supposing I want Excel to simply accept a text string AS ENTERED? For example ...
KCal ... which has the first TWO letters in upper case and the second two letters in lower case.
I am using Microsoft Office Excel 2003, Service Pack 3
Thank you!