How to Change Text Case In Excel

Change Case Of Excel Cells Text

Excel Change Case

Change case of text in selected cells in Excel to upper case, lower case, proper case, or capitalize the first letter in each cell. Dose for Excel‘s Change Case utility can implement this with one click on huge number of cells.

How to Change Text Case In Excel

Click DOSE » Text » Change Case

How to Change Text Case In Excel

To UPPER case

  1. Select range of cells to change all WORDS LETTERS IN CELLS TO UPPER CASE, and check To UPPER case option.
  2. Then click Apply. You will see the result as shown in the below screenshot.
Change text case to upper in Excel

To lower case

  1. Select range of cells to change all words letters to lower case, and check To lower case option.
  2. Then click Apply. You will see the result as shown in the below screenshot.
Change text case to lower in Excel

To Proper Case

  1. Select range of cells to Capitalize Each Word and change Other letters To lowercase, and check To Proper case option.
  2. Then click Apply. You will see the result as shown in the below screenshot.
Change text case to proper in Excel

Capitalize each cell

  1. Select range of cells to Capitalize the first character within a cell, and check Sentence case option.
  2. Then click Apply. You will see the result as shown in the below screenshot.
Change text case to sentence in Excel

Demo


More Features:

Excel Advanced Functions

Use Built-In Advanced Functions In Excel You can quickly use built-in functions without writing VBA…

Excel Random Generator

Generate Random Data (Numbers, Date, String, etc…) Sometimes you want to generate some random data…

Excel Color Duplicates

Color Duplicated Cells Values In Groups In Excel Color the duplicated cells values, each group…

Dose for Excel Languages

Dose for Excel Multi-Language Dose for Excel Add-In supports many languages, you can change the…

Excel Split

In Excel, split the first and last word, or divide them by a delimiter or…

Excel Delete Rows

Excel Highlight Or Delete Any Type Of Rows Highlight or delete items that are identical,…


Scroll to Top