Excel Change Case (Table of Contents)
Introduction to Change Case in Excel
As we know from childhood, there are two kinds of cases which we mostly use; those are upper case and lower case. While we are working on a word document, it will warn us to adjust or will adjust in case if we wrongly give lowercase after a full stop or at the beginning of the statement, but this feature is not available in Excel. There are multiple ways to convert one case to another case in Excel and convert to correct the case.
How to Change Case in Excel?
One way to convert the text from one case to another case is to use functions in excel. We have functions like “Upper”, “Lower”, and “Proper”. We will see one by one how to change case in Excel and the impact of each because each one has its own features. Let’s understand How to Change the Case in Excel with some examples.
Example #1 – Change Case to Upper Case
This function helps to convert the text from any case to upper case. It is very easy to convert to upper case using this function. Try to input a small data table with all small case.
Observe the above screenshot; I have input January to July months in small case letters. Now our task is to convert them to upper case using the UPPER function. The data is in column A; hence input the function in column B.
Syntax of the function is =UPPER(text). Observe the below screenshot for reference.
Here instead of text, give the cell address which we want to convert to uppercase. Here the cell address is A1.
Observe the above screenshot, the month in cell A1 is converted into uppercase in B1. Now apply this to all other cells by dragging the formula until data is available or selecting the cell B1.
Then double click on the right bottom corner of the square.
Now data is converted to Upper case, but it is not in the required place of a spreadsheet. So, copy the data that is converted in uppercase and select cell A1 and right click then, the below pop up menu will appear.
Choose the Paste Special option and select Values. Then click on OK.
Then the text will paste like below.
After deleting the column with formulas, we will get results as shown below.
Example #2 – Change Case to Lower Case
Up to now, we have seen how to convert small case to upper case. Now we will see how to convert an upper-case text into lower case text. This is also quite similar to the upper case function still; we will see one example of how to convert to lower case.
Consider the example which we already converted to upper case. Now we will convert the same months to lower case.
The syntax of lower is also similar to upper that is =LOWER(Text). Observe the below screenshot for reference.
In place of text, we will input the Cell Address of text that we want to convert to lower. And press Enter. Then apply this to all other cells by dragging the formula until data is available.
As the text is converted to lower case, copy text and paste the data as similar to how we did in the upper case and delete the formula cells.
With this, we covered how to convert data a lower-case text to upper case and upper-case text to lower case. We have one more function called proper, which we have to discuss.
Example #3 – Change any case to a Proper case
One more function is available to convert from one case to another case, but it is quite different from upper and lower functions. Because “UPPER” will convert everything to upper case and “LOWER” will convert everything to lower case, but “PROPER” will convert every first letter of the word to upper case and the remaining into lowercase.
Consider the below text, which is in a mixed-format; some letters are in the upper case and some lowercase letters. Now we will apply a proper function to these texts and will check how it converts.
The syntax for proper is similar as upper and lower =PROPER(text); find the below screenshot for reference.
Now select the cell address in place of text.
Now apply this to all other cells also by dragging the formula until data is available.
Observe text ‘J’ is capital in January ‘, I’ is capital in Is ‘F’ is capital in First ‘M’ is capital in Month. If we compare both texts, all the first letters of the word are uppercase.
Now we will see how it will convert if the entire text is in the upper case.
Even if all the texts are in the upper case, they will be converted in the same way. Hence it is not a concern what case we are using; whatever case, maybe it will convert into its own pattern (the first letter is the upper case in every word).
Up till now, we seen how to convert using function now will see how to change case with Flash fill in excel.
Example #4 – Flash fill
Flash fill helps in a few cases when we want to convert the text into a particular pattern. Here we will discuss the names, but you can use this depending on the situation. Consider the below list of names.
If we want only the first letter as upper case, give the next column pattern. Now select the next empty cell and select the option Flash Fill. Flash fill is available under the Data menu; please find the below screenshot for reference.
Once we click on the flash fill, it will fill the similar pattern as the above two names.
If we want to convert the first part of the name alone to the upper case, we have to use the combination of upper and left functions together.
If we observe the formula, the result of a left function is “Kumar”, and the upper function converts that Kumar name to the upper case; hence the result is “KUMAR” similarly for the other cells too.
Things to Remember About Change Case in Excel
- Three functions help to convert the text from one case to another case.
- Upper converts any case text into upper case
- Lower converts any case text into lower case
- Proper convert any case text into a format of the first letter of the word will be upper case.
- If we want to take the help of a word document, we can copy the text from excel and paste the text into a word document and use the shortcut Shift + F3 to convert the text to upper, lower, and first letter upper formats. Now copy from word and paste it into excel.
This is a guide to Change Case in Excel. Here we discuss how to Change Case in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –