When working with huge data compiled by several people, oftentimes we run into a situation where some have their entries made all in CAPS while some just enter in lower case. Now to make it presentable, you need to have a uniform format. If you are in such a situation, then this article will guide you on how to change the text case to your desired format in a Microsoft Excel document.
Change Text Case using UPPER, LOWER, PROPER Functions
Excel’s UPPER, LOWER, and PROPER Functions are the easiest way to convert the text’s case. Using the UPPER Function you can convert text to Upper Case, Using the LOWER Function you can convert text to Lower Case, and by using the PROPER Function you can Capitalize the first character of each word.
Change Text to Upper Case using UPPER Function in Excel
If you want to change the text to all capital or all upper case, then with the use of the UPPER function you can convert the text to upper case. To explain this, let’s take a sample list of names.
To convert the above text to all upper case we will use the =UPPER() Function. First, we will understand the sample data. In Column A, we have the list of six names, starting from Row 2. In Column B we will use the UPPER Function and refer to the data from Column A into it for conversion. So, to do that all we need to do is, click on Cell B2 and type =UPPER(A2), and press Enter.
In the resulting screenshot below, you will see, the text taken from cell A2 is copied to B2, and converted to upper case. This is how simple it is to convert the text from any case to upper case.
Even if there is no list or reference data to convert, you can still use the UPPER function to convert a random phrase or paragraph of data. To do that click on any cell in the spreadsheet, type =UPPER(“your content”), and within the bracket paste your text as shown in the image below, and press Enter. Your text will be converted to all upper case.
Using UPPER Function to change the text case of a random text:
Result of the above function:
Change Text to Lower Case using LOWER Function in Excel
If you want to change the text to all lower case or all small case, then with the use of the LOWER function you can convert the text to lower case. To explain this, let’s use the same sample list of names, but we have changed some text’s case to capital.
To convert the above text to all lower case we will use the =LOWER() Function. First, we will understand the sample data. In Column A, we have a list of six names, starting from Row 2. Some names are in all capital format and others have the first alphabet of each word capital. In Column B we will use the LOWER Function and refer to the data from Column A into it for conversion. So, to do that all we need to do is, click on Cell B2 and type =LOWER(A2), and press Enter. Further, you can drag the pointer to copy the formula for other cells as well.
You will see, the text taken from cell A2 is copied to B2, and is converted to all lower case. This is how simple it is to convert the text from any case to a lower case.
Even if there is no list or reference data to convert, you can still use the LOWER function to convert a random phrase or paragraph of data. To do that click on any cell in the spreadsheet, type =LOWER(“your content”), and within the bracket paste your text as shown in the image below and press Enter. Your text will be converted to all lower case.
Using LOWER Function to change the text case of a random text:
Result of the above function:
Change Text to Upper Case using PROPER Function in Excel
If you want to change the text case to Proper i.e. to Capitalise the first alphabet of each word, then use PROPER Function to achieve this. To explain, let’s use the same sample list of names here again. We changed the text case of a few names, such that some names are in all capital format and others are in lower case.
To convert the above text, we will use the =PROPER() Function. First, we will understand the sample data. In Column A, we have the list of six names, starting from Row 2. In Column B we will use the PROPER Function and refer to the data from Column A into it for conversion. So, to do that all we need to do is, click on Cell B2 and type =PROPER(A2), and press Enter. Further, you can drag the pointer to copy the formula for other cells as well.
You will see, the text taken from cell A2 is copied to B2, and the text case is converted. This is how simple it is.
Even if there is no list or reference data to convert, you can still use the PROPER function to convert a random phrase or paragraph of data. To do that click on any cell in the spreadsheet, type =PROPER(“your content”), and within the bracket paste your text as shown in the image below and press Enter. Your text will be converted.
Using PROPER Function to change the text case of a random text:
Result of the above function:
Conclusion
In this article we explained how using the UPPER, LOWER, and PROPER Functions of Excel, we can convert the text cases easily as per our requirements. If you have any questions, comment below.
