Change Case in Excel

Changing Case of Text in Excel

Excel provided a set of options to deal with text. But, there is a problem with Excel, it does not have the option to change the case of the text in excel worksheets. It provided three major functions to convert the text to lower case, upper case, and proper case. The function includes PROPER, UPPER, and LOWER. These are helpful in minimizing the problems in changing the case. In this article, we will learn how to change text case in excel.

Functions used to Change Case in Excel

The following are the functions used to change text case in excel

#1 – Lowercase in Excel

To convert all the text presented in a cell to lowercase, use the LOWER function. Use the following formula.

change case 1

#2 – Uppercase in Excel

To convert all the text presented in a cell to uppercase, use the UPPER function. Use the following formula.

change case 2

#3 – Proper Case in Excel

To convert all the text presented in a cell to the title case, use the PROPER function. Use the following formula.

change case 3

Only one cell should be selected to apply the change case functions. When a formula is entered, the hover is displayed by mentioning the purpose of the function. After entering a formula, the ENTER key should be pressed on the keyboard to have the desired result.

How to Change Case in Excel? (with Examples)

The change case functions are used in two ways in Excel.

  • First method: Directly enter the function name in a cell.
  • Second method: Insert the functions from the Formula Tab.

The following are some examples to understand how to change case.

Example#1: Change Text to Lowercase using the LOWER function

The following example is considered to explain the use of the LOWER function. Several steps are required to display the text in the required format.

Example 1.1

The above figure shows the sample data to convert into a lower case. The formula of the lower function should be entered into the highlighted cell.

  • Step 2: Go to the top of the ribbon and click on the Formula tab to select the function, as shown in the image. The description for the LOWER (text) is displayed by hovering on the function.

Example 1.2

  • Step 3: Once you click on a LOWER function, the function argument window will open.

Example 1.3

  • Step 4: Cell address should be entered into the function arguments box, and results are displayed in the figure.

Example 1.4

Press Enter to see the change in text case.

Example 1.5

  • Step 5: The formula is dragged to apply to the remaining cells to convert data presented in the next rows.

Example 1.6

Example#2: Converting Text to Uppercase Using UPPER function

The following example is considered to explain the use of the UPPER function. Several steps are required to display the text in the capitalized format

  • Step 1: Select the cell where you want to convert into upper case

change case example 2.1

The above figure shows the sample data to convert into the upper case. The basic excel formulasBasic Excel FormulasThe term "basic excel formula" refers to the general functions used in Microsoft Excel to do simple calculations such as addition, average, and comparison. SUM, COUNT, COUNTA, COUNTBLANK, AVERAGE, MIN Excel, MAX Excel, LEN Excel, TRIM Excel, IF Excel are the top ten excel formulas and functions.read more of the upper function should be entered into the highlighted cell.

  • Step 2: Go to the top of the ribbon and click on the Formula tab to select the function, as shown in the image. The description for the UPPER (text) is displayed by hovering on the function.

change case example 2.2

  • Step 3: Once you click on an UPPER function, the function argument window will open. The UPPER function is found from the several functions available.

change case example 2.3

  • Step 4: Cell address should be entered into the function arguments box, and the result is displayed in the figure

change case example 2.4

Press Enter to see the change in text case.

change case example 2.5

  • Step 5: The formula is dragged to apply to the remaining cells to convert data presented in the next rows.

change case example 2.6

Example#3: Converting Text to Title case Using the PROPER function

The following example is considered to explain the use of the PROPER in excelPROPER In ExcelThe Proper Excel function converts the given input to proper case, which means that the first character in a word is in uppercase and the rest of the characters are in lower case. To use this function type =PROPER( and provide string as input).read more function. Several steps are required to display the text in the title case.

  • Step 1: Select the cell where you want to convert into title case

change case example 3.1

The above figure shows the sample data to convert into title case. The formula of the title function should be entered into the highlighted cell.

  • Step 2: Go to the top of the ribbon and click on the Formula tab to select the function, as shown in the image. The description for the PROPER (text) is displayed by hovering on the function.

change case example 3.2

  • Step 3: Once you click on a PROPER function, the function argument window will open. PROPER function is found from the several functions available

Example 3.3

  • Step 4: Cell address should be entered into the function arguments box, and the result is displayed in the figure

Example 3.4

Press Enter to see the change in text case.

Example 3.5

  • Step 5: The formula is dragged to apply to the remaining cells to convert data presented in the next rows.

Example 3.6

Example#4: Changing the Text Using the Flash Fill Method

  • Step 1: Type the data in lower case to convert into upper case

change case example 4.1

  • Step 2: Type the same data in a highlighted cell in UPPER case and press ENTER to move the cursor to below cell

Upper case

  • Step 3: Go to the ‘Data’ tab and click on the ‘Flash Fill’ option in excel under the Data Tools Group. The remaining data is automatically typed by converting into the UPPER case as shown in the below figure

Flash Fill

Things to Remember

  • The change case functions such as LOWER, UPPER, and PROPER are not worked on the numerical data, special characters, and punctuations.
  • When a PROPER function is used, the S letter after the apostrophe is converted into the uppercase. Here‘s’ letter should be converted manually into the lower case.
  • The change case functions accept only one input at a time. It is hard to change the case of text presented in all cells.
  • There is no option to select only the particular text to change the case.

Recommended Articles

This has been a guide to Change Case in Excel. Here we discuss how to change cases in excel using 1) Lower Function, 2) UPPER Function, 3) PROPER Function, and 4) FLASH FILL with examples. You may also look at these useful functions in excel –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>