Excel Change Text Case – Upper, Lower, Proper

Excel Change Text Case | UPPER, LOWER, PROPER

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 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 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 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 Covert Text in String to Upper Case

Sometimes you need to convert the text into 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 wrote is =UPPER(A2)

Step 2: We want to convert the text of A2 into B2. As you press enter key all the text will be converted into upper case.

When you want to convert the whole column into upper case you simply convert the first cell and then drag the mouse and select the cell. It will automatically convert the column into 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 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 wrote is =LOWER(A3).

Step 2: We want to convert the text of A3 into B3. As you press enter key all the text will be converted into lower case.

When you want to convert the whole column into lower case you simply convert the first cell and then drag the mouse and select the cell. It will automatically convert the column into 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 wrote is =PROPER(A4).

Step 2: We want to convert the text of A4 into B4. As you press enter key all the text will be converted into 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.

 

Hope you like our tutorial for more cool and amazing trick of excel Like our Excel Superstar Facebook Page and subscribe to our Excel Superstar YouTube channel. Excel Superstar is the leading online training company, which provides Online Excel Course in Hindi. Connect with us and become an Excel Superstar.