How to Change Upper Case to Lower Case in Excel (5 Effective Methods)

You might need to convert upper case data into lower case while working with text data, such as names or addresses, which is frequently the case. We often download data from databases or websites for our work that is all upper case. Excel makes it incredibly simple to go from upper case to lower case or vice versa. All you need to know is the appropriate functionality or formula. By studying this article you’ll learn how to change upper case to lower case in Excel. Here, we’ll try to discuss how to change upper case to lower case in Excel.


Download Practice Workbook


5 Methods to Change Upper Case to Lower Case in Excel

You can use various formulas and features to change from uppercase to lowercase. To do this, we have made a dataset named Some Owners of Cars in California. We have columns which are Car Brand, Profession, Name in Uppercase.

how to change uppercase to lowercase in excel

Let’s see how we can change this uppercase into lowercase.


1. Applying LOWER Function

Firstly, you can change uppercase into lowercase by using the LOWER function. To do this follow the below steps.

  • Initially, you need to write the formula in E5 cell below to make this change.
=LOWER(D5)

Here, D5 refers to the Name in Uppercase which needs to be changed to lowercase.

how to change uppercase to lowercase in excel using LOWER function

  • Secondly, press ENTER to find the output.
  • Thirdly, use Fill Handle to get all the Names in Lowercase.

After doing that, you’ll get the following output.

how to change uppercase to lowercase in excel using LOWER function

Read More: How to Change Lowercase to Uppercase in Excel (6 Methods)


2. Utilizing Flash Fill Feature to Change Upper Case to Lower Case in Excel

Although the formula approach is simple and obvious, there is another approach that is equally simple and practical for changing the case of text in Excel. Specifically, by utilizing the Flash Fill feature. Flash Fill is a relatively handy feature in Excel that fills cells automatically for you based on patterns it detects.

To use this feature you can follow the steps below.

  • Firstly, enter the text from cell D5 in cell E5 using lowercase letters.

how to change uppercase to lowercase in excel using Flash Fill

  • Secondly, select Flash Fill from the Data Tools group on the Data tab of the ribbon.

how to change uppercase to lowercase in excel using Flash Fill

You will have the outputs from cell E5 to E15 like this.

how to change uppercase to lowercase in excel using Flash Fill

  • Now that you have all of the suggested values, you must select the Flash Fill icon in order to accept the values and fill the cells.

how to change uppercase to lowercase in excel using Flash Fill

You changed all of the names in column D to lowercase in column E, producing the same final result as in the preceding section.

Read More: How to Change Case for Entire Column in Excel (7 Amazing Ways)


3. Using Power Query to Change Upper Case to Lower Case in Excel

Use the Power Query as another method of changing to lowercase. If you need to convert your data, this tool will come in very handy. To use this feature you can follow the steps below.

  • Firstly, choose any cell in the dataset.
  • Secondly, select From Table/Range under the Data

how to change uppercase to lowercase in excel using Power Query

As a result, there will be a pop-up which is Create Table bar.

how to change uppercase to lowercase in excel using Power Query

  • Thirdly, mark My table has headers.
  • Fourthly, click OK. There will be a Power Query Editor window.
  • Select the column of Name in Uppercase.
  • Go to Add Column> Format> lowercase.

how to change uppercase to lowercase in excel using Power Query

A new lowercase will be created beside the Name in the Uppercase column.

  • Fifthly, go to File tab > Close & Load.

how to change uppercase to lowercase in excel using Power Query

A new worksheet with the following data will be added to your Excel file.

  • Sixthly, add the title and change the header to Name in Lowercase. And your final output is ready.

how to change uppercase to lowercase in excel using Power Query

Read More: How to Change Lowercase to Uppercase with Formula in Excel (3 Ways)


4. Utilizing Microsoft Word

You can also use Microsoft Word to make changes in the text very easily. You can follow the steps below.

  • Firstly, copy the D5:D15 cell range in Excel that you want to modify.

how to change uppercase to lowercase in excel using Microsoft Word

  • Secondly, open a new Microsoft Word document.
  • Thirdly, copy the cells, then paste them in the word file.

how to change uppercase to lowercase in excel using Microsoft Word

  • Fourthly, choose the texts you wish to alter the case.
  • Fifthly, select the Change Case i.e. Aa icon from the Home tab. Choose lowercase from the list.

how to change uppercase to lowercase in excel using Microsoft Word

The texts will change to lowercase.

how to change uppercase to lowercase in excel using Microsoft Word

  • Sixthly, copy the texts and paste to Name in Lowercase.

how to change uppercase to lowercase in excel using Microsoft Word

Read More: How to Change Case in Excel Sheet (8 Quick Methods)


5. Applying VBA to Change Upper Case to Lower Case in Excel

You can also use VBA code to make this transformation. The steps are given below.

  • Firstly, copy and paste the uppercase texts into the column of Name in Lowercase.
  • Select the texts of this column. You will now apply VBA to change these uppercase texts into lowercase texts.
  • Go to Developer tab > Visual Basic.

 using VBA

  • Secondly, click Insert > select Module.

 using VBA

A blank Module will appear.

 using VBA

  • Thirdly, Copy and Paste the code below inside the Module.
Sub Lower_case()

For Each Cell In Selection

If Not Cell.HasFormula Then

Cell.Value = LCase(Cell.Value)

End If

Next Cell

End Sub

using VBA

The above VBA code was found from Wallstreetmojo.com.

Fourthly, click Run > select Run Sub/UserForm (Use F5 key as shortcut).

using VBA

  • Finally, you’ll get your output as lowercase texts from E5 to E15.

using VBA


Things to Remember

  • Using the LOWER function is simple and easy among other methods to change uppercase into lowercase.
  • You can use Flash Fill by pressing ALT + E In many cases this doesn’t work. Then you can use the procedure that we have described above.
  • Power Query is a very effective tool in Excel not only to change text patterns but also to organize data in various ways.

Conclusion

By studying this article, you’ll definitely be able to make changes in your text pattern from uppercase to lowercase. Please feel free to visit our official Excel learning platform ExcelDemy for further queries.


Related Articles

Towhid

Towhid

Name: MD SHAJRATUL ALAM TOWHID Date of Birth: 6th September 1996 Religion: Islam Nationality: Bangladeshi

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo