Table of Contents
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
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, a LOWER function is helpful. To use this function, the following parameters and formulas should be used.
#2 – Uppercase in Excel
To convert all the text presented in a cell to uppercase, the UPPER function is helpful. To use this function, the following parameters and formulas should be used.
#3 – Proper Case in Excel
To convert all the text presented in a cell to the title case, PROPER function is helpful. To use this function, the following parameters and formulas should be used.
Only one cell should be selected to apply the change case functions. When a formula is entered 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?
The change case functions are used in two ways in Excel.
- First method: Directly entering the function name in a cell as shown in the below figure
- Second method: Inserting the functions from the Formula Tab.
The following are some examples to understand how to change case in excel.
Example#1: Change Text to Lowercase Using 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.
Step1: Select the cell where you want to convert text case in excel into lower case
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.
Step2: 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.
4.9 (1,353 ratings)
Step3: Once you click on a LOWER function, the function argument window will open.
Step4: Cell address should be entered into function arguments box and results are displayed in the figure.
Press Enter to see the change in text case in excel.
Step5: Formula is dragged to apply to the remaining cells to convert 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
Step1: Select the cell where you want to convert into upper case
The above figure shows the sample data to convert into the upper case. The excel formula of the upper function should be entered into the highlighted cell.
Step2: 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.
Step3: Once you click on an UPPER function, the function argument window will open. The UPPER function is found from the several functions available
Step4: Cell address should be entered into function arguments box and the result is displayed in the figure
Press Enter to see the change in text case in excel.
Step5: Formula is dragged to apply to the remaining cells to convert data presented in the next rows.
Example#3: Converting Text to Title case Using PROPER function
The following example is considered to explain the use of the PROPER function. Several steps are required to display the text in title case.
Step1: Select the cell where you want to convert into title case
The above figure shows the sample data to convert into title case. The formula of title function should be entered into the highlighted cell.
Step2: 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.
Step3: Once you click on a PROPER function, the function argument window will open. PROPER function is found from the several functions available
Step4: Cell address should be entered into function arguments box and the result is displayed in the figure
Press Enter to see the change in text case in excel.
Step5: Formula is dragged to apply to the remaining cells to convert data presented in the next rows.
Example#4: Changing the Text Using the Flash Fill Method
Step1: Type the data in lower case to convert into upper case
Step2: Type the same data in a highlighted cell in UPPER case and press ENTER to move the cursor to below cell
Step3: Go to the ‘Data’ tab and click on the ‘Flash Fill’ option under the Data Tools Group. The remaining data is automatically typed by converting into the UPPER case as shown in the below figure
Things to Remember Here
- 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
You can download this Change Case Excel Template from here – Change Case Excel Template
Recommended Articles
This has been a guide to Change Case in Excel. Here we discuss how to Change Case in Excel using 1) Lower Function 2) UPPER Function 3) PROPER Function and 4) FLASH FILL with examples and downloadable excel templates. You may also look at these useful functions in excel –
- Insert Delta Symbol in Excel using Shortcut Key
- Examples of $ Symbol in Excel
- Excel Chi-Square Test Examples
- ToolBar on Excel
- How to Separate Text in Excel?
- Add Text in Excel Formula
- Wrap Text Excel
- Convert Text to Numbers Excel
- 35+ Courses
- 120+ Hours
- Full Lifetime Access
- Certificate of Completion