Change Case 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. Instead, it provides three major functions to convert the text to lower, upper, and proper cases. It helps to minimize the problems in changing the cases. This article will teach how to change text cases in Excel.

1. Excel provides three major functions to convert the text to lower, upper, and proper cases to change the case of text in Excel worksheets. It also helps to minimize any issues that may arise when changing the text's case.
2. Lowercase, uppercase, and proper case are the functions one may use to change the text case in Excel.
3. Change case functions (LOWER, UPPER, PROPER) don't work on numbers, special characters, or punctuation and require manual conversion of letters. These functions accept one input at a time and contain no option to select specific text to change the case.

The following are the functions used to change text case in Excel:

#1 - Lowercase In Excel

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

#2 - Uppercase in Excel

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

#3 - Proper Case in Excel

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

We should select only one cell 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, we should press the "ENTER" key on the keyboard to have the desired result.

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: We must select the cell we want to convert into the upper case.

The above figure shows the sample data to convert into the upper case. But, first, we should enter the basic Excel formulas of the upper function into the highlighted cell.

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

• Step 3: Once we click on an UPPER function, the “Function Arguments” window will open. The UPPER function is found among the several functions available.

• Step 4: The cell address should be entered into the "Function Arguments" box, and the result should be displayed in the figure.

Now, press the "Enter" key to see the change in the text case.

• Step 5: We will drag the formula to apply to the remaining cells to convert the data presented in the next rows.

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.

Step 1: We must select the cell where you want to converts the text case in Excel into lowercase

The above figure shows the sample data converted into a lower case. We should enter the formula of the lower function into the highlighted cell.

• Step 2: First, we must 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.

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

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

Now, press the "Enter" key to see the change in the text case.

• Step 5: Now, we will drag the formula to apply to the remaining cells to convert the data presented in the next rows.

The following example is considered to explain the use of the PROPER in the Excel function. Several steps are required to display the text in the title case.

• Step 1: We must select the cell we want to convert into a title case.

The above figure shows the sample data to convert into a title case. We should enter the formula of the title function into the highlighted cell.

• Step 2: Then, we must 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.

• Step 3: Once we click on a PROPER function, the "Function Arguments" window will open. The PROPER function is found among the several functions available.

• Step 4: We must insert the cell address into the "Function Arguments" box, and the result is displayed in the figure.

Now, press the "Enter" key to see the change in the text case.

• Step 5: Next, we will drag the formula to apply to the remaining cells to convert the data presented in the next rows.

• Step 1: We must type the data in lower case to convert it into upper case.

• Step 2: Now, type the same data in a highlighted cell in the UPPER case and press the "ENTER" key to move the cursor to the below cell.

• 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 it into the UPPER case, as shown in the below figure.

If you need to change the case of the selected text quickly, you can simply press SHIFT + F3 until the text is transformed to the desired case. This can help you save time and effort while working on your document.

• The change case functions such as LOWER, UPPER, and PROPER do not work on the numerical data, special characters, and punctuations.
• While using a PROPER function, the "S" letter after the apostrophe is converted into the uppercase. So here, we should convert letters manually into lower case.
• The change case functions accept only one input at a time. Therefore, 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.

This article is 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: -

• Insert Delta Symbol in Excel
• $ Symbol in Excel 
• Chi-Square Test in Excel
• Excel ToolBar