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 word document it will warn 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 of the ways to convert the text from one case to other case is using 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 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 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 also by dragging the formula until data is available or select 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 required place of a spreadsheet. So, copy the data that is converted in uppercase and select the 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 as 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 as how we did in 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 Proper case
There is one more function that 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 upper case and some letters in lower case. Now we will apply a proper function to these texts and will check how it converts.
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 the texts all the first letters of the word are uppercase.
Now we will see how it will convert if the entire text is in upper case.
Even if all the texts are in upper case it 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 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 first letter as upper case, then give the pattern in the next column. 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 above two names.
If we want to convert the first part of the name alone to 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 upper function converts that kumar name to 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 converts any case text into a format of the first letter of the word will be upper case.
- If we want to take help of word document, we can copy the text from excel and paste the text in 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 in excel.
This is a guide to Change Case in Excel. Here we discuss how to Change Case in Excel along with practical examples and downloadable excel template. You can also go through our other suggested articles –