how to change lowercase to uppercase in excel 2016

How to change uppercase and lowercase text in Microsoft Excel

Updated: 12/31/2020 past Figurer Promise

There are ways to alter the case of text to uppercase, lowercase, or proper case in Microsoft Excel. Below are all of the diverse methods that tin be used.

Note

There is no keyboard shortcut to modify the example of highlighted text in a jail cell.

Changing the case using functions

Three different functions can be used in Excel to change the capitalization of text in a jail cell. Below is an overview of each of these functions.

=LOWER( )

Using the lower function takes the value of any cell, and converts information technology to lowercase text. For example, if you lot wanted to prove in prison cell B1 a lowercase version of the text in A1, y'all could blazon the beneath office into B1.

=LOWER(A1)

=PROPER( )

Using the proper part takes the value of any cell, and converts it to proper example. For example, if yous wanted to testify in cell B1 a proper case version of the text in A1, you could blazon the below role into B1.

=PROPER(A1)

=UPPER( )

Using the upper part takes the value of any cell, and converts information technology to uppercase text. For example, if y'all wanted to show in cell B1 an uppercase version of the text in A1, you lot could type the beneath office into B1.

=UPPER(A1)

Tip

One time you've created any of the higher up formulas, y'all can use the Excel Fill up Handle to copy the role into as many cells as needed.

Use Excel Flash Fill

Users who are using Excel 2022 and higher also have the pick to utilize Excel Flash Fill to automatically fill up cells to how you want them to be formatted. Beneath is an example of how Flash Fill up tin can complete text with the example you lot want to utilize.

Enter the text how you want it to announced. In our example motion-picture show, we have names in column A and desire column B to use proper case for each of the names.

In one case the properly formatted version of the text is inserted, press the keyboard shortcut Ctrl+Due east, or click Data and and then Flash Make full to fill out the remaining cells.

One time complete, each of the names should be in column B with the proper example.

Re-create and paste

If none of the above solutions work, copy and paste the text in Excel to another application that can modify the case. For example, yous could copy and paste text from Excel to Microsoft Word and use the shortcut key Shift+F3 to alter text betwixt uppercase, lowercase, and proper example.

Tip

Employ our text tool to catechumen any text from capital to lowercase.