Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

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.

Change case of text with Excel Functions

Change case of text with Kutools for Excel

Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
  • 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; Send Personalized Emails to Multiple Recipients in Bulk.
  • Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
  • More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.

arrow blue right bubble Change case of text with Excel Functions

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:

doc-change-case1

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:

doc-change-case2

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:

doc-change-case3

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.


arrow blue right bubble 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:

doc-change-case4

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:

doc-change-case5

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 Solves Most of Your Problems, and Increases Your Productivity by 80%

  • 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 than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial.
kte tab 201905

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!
officetab bottom
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Victor · 3 years ago
    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!