These functions are used in Excel when your Excel spreadsheet contains a lot of text. Unlike Microsoft Word, Excel does not change the case on its own. Excel Change Text Case
This tutorial will give you a look at three functions that allow you to easily change the cases of text in Excel: Upper, Lower, and Proper.
Upper case – Excel Change text Case
This function changes the text into upper cases. It converts all lower cases letter in a string to upper cases.
The Syntax to change the case to Upper case is =UPPER (text) where the text is the only parameter required to change the case. Here the text refers to the cell or text you want to change the case of.
Lower case – Excel change Text case
This function changes the text into lower cases. It converts all upper cases letter in a string to lower cases.
The Syntax to change the case to lower case is =LOWER (text) where the text is the only parameter required to change the case. Here the text refers to the cell or text you want to change the case of.
Proper case – Excel change Text case
This function is used to change the first letter of the word to capital and remaining all others to lower case.
The Syntax to change the case to proper case is =PROPER (text) where the text is the only parameter required to change the case. Here the text refers to the cell or text you want to change the case of.
How to Convert Text in String to Upper Case
Sometimes you need to convert the text into the upper string. So the steps to convert the text into upper cases as follow:
Step 1: Type the formula in the cell-like suppose B2. The formula to be written is =UPPER(A2)
Step 2: We want to convert the text of A2 into B2. As you press the enter key all the text will be converted into upper case.
When you want to convert the whole column into the upper case you simply convert the first cell and then drag the mouse and select the cell. It will automatically convert the column into the Upper case.
You can also change the text string into upper case in Excel with VBA.
How to Convert Text in String to Lower Case
Sometimes you need to convert the text into the upper string. So the steps to convert the text into upper cases as follow:
Step 1: Type the formula in the cell-like suppose B3. The formula to be written is =LOWER(A3).
Step 2: We want to convert the text of A3 into B3. As you press the enter key all the text will be converted into lower case.
When you want to convert the whole column into the lower case you simply convert the first cell and then drag the mouse and select the cell. It will automatically convert the column into a Lower case.
You can also change the text string into upper case in Excel with VBA.
How to Convert Text in String to Proper Case
This case will convert your text with the first letter capital and remaining all small letter or lower case.
Step 1: Type the formula in the cell-like suppose B4. The formula to be written is =PROPER(A4).
Step 2: We want to convert the text of A4 into B4. As you press the enter key all the text will be converted into the proper case.
Conclusion:
This tutorial is useful when we want to present the data or when we remove printout. The case used makes the data presentable. This is specially used while making reports.
Leave a Reply