Changing Case of Text 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

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.

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 the 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.

  • Step 1: We must select the cell where you want to converts the text case in Excel into lowercase Convert The Text Case In Excel Into Lower CaseThere are six methods to change lowercase in excel - Using the lower function to change case in excel, Using the VBA command button, VBA shortcut key, Using Flash Fill, Enter text in lower case only, Using Microsoft word.
  • read more.

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 LOWER (text) description 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 should be 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.

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: 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 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 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.

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

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

The following example is considered to explain the use of the PROPER in the ExcelPROPER In The 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: 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: 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.

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

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

  • 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.

Things to Remember

  • The change case functions such as LOWER, UPPER, and PROPER do not work on the numerical data, special characters, and punctuation.While using a PROPER function, the “S” letter after the apostrophe is converted into the uppercase. So here, we should convert letters manually into lowercase.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. We discuss how to change text case in Excel using LOWER, UPPER, PROPER, and FLASH FILL functions with examples. You may also look at these useful functions in Excel: –

  • Insert Delta Symbol in ExcelInsert Delta Symbol In ExcelIn Excel, Delta symbol is used over time to show change. This is used to create dashboards with eye-catching colors. There are two types of delta symbols like the Filled delta symbol and the empty delta symbol. Auto-correction is the best option if the delta symbol is using continuously. The user can insert the Delta symbol (Δ) in excel using the Insert option, ALT + 30 shortcut key, changing the font name, CHAR formula, excel AutoCorrect feature or custom number formatting with Delta symbol.read more$ Symbol in Excel Chi-Square Test in ExcelChi-Square Test In ExcelIn Excel, the Chi-Square test is the most commonly used non-parametric test for comparing two or more variables for randomly selected data. It is a test that is used to determine the relationship between two or more variables.read moreExcel Excel The toolbar, also known as the quick access toolbar, is located on the left top-most side of the excel window and has only a few options by default, such as save, redo, and undo. Users can, however, customize it to their liking and add any option or button to make it easier to access the commands.read moreToolBarToolBarThe toolbar, also known as the quick access toolbar, is located on the left top-most side of the excel window and has only a few options by default, such as save, redo, and undo. Users can, however, customize it to their liking and add any option or button to make it easier to access the commands.read more