How To Change From Lower Case to Upper Case in MS Excel

While you are working on a task on your computer, it’s important to work smartly in order to save time. This in turn, will increase your productivity. For instance, if you entered text in MS Excel in lower cases and now you want to convert them to upper cases, you can use a shortcut. Wondering how to achieve that? Let’s see how.


ADVERTISEMENT

Method 1: How To Change The Case of Text in MS Excel

 

Step 1: Open the MS Excel sheet > select the field on the right side > right-click on the field > select Insert.

 

1st Field On The Right Right Click Insert

 

Step 2: In the Insert dialog box > select Entire column > press OK to create a new column.

 

Inser Dialog Entire Column Ok

 

Step 3: In the new column > select the 1st field (here we selected the empty field next to Small letters) > type =upper ( .

Now, select the F4 field which contains the text – Small letters > go back to the new column > close the bracket > looks like this > =upper(F4) > hit Enter. This will convert the “Small letters” to all upper case in the new column.

 


ADVERTISEMENT

New Column Type = Upper ( Select Small Letters Go Back To New Column Enter

 

Step 4: Place the mouse on the bottom right (containing SMALL LETTERS)> double-click to convert all the text to Upper case in the new column.

 

New Column Double Click All Uuper Case

 

Step 5: Now, select all text in the new column > press Ctrl + C on your keyboard to copy the selected text > now, go to the upper left side of the document > click on Paste > select Paste Special.

 

Select Entire New Column Copy Paste Paste Special

 

Step 6: Next, click on Value > press OK.

 

Pate Special Dialog Value Ok

 

Step 7: Select the field containing the text – Small letters in lower case and hit Enter to convert all the text in that column to upper case.

 

Select Field Small Letters Hit Enter

 

Step 8: Next, select the new column > right-click > select Delete > select Entire column.

 

Select New Column Right Click Select Delete

 

Step 9: In the Delete dialog box > select Entire column > hit Enter.

 

Delete Dialog Entire Column Ok

 

 

Step 10. To convert from upper case to lower case, follow the same process as above from Step 1 to Step 2.

Then for Step 3 > in the new column > select the 1st field (here we selected the empty field next to Small letters) > type =lower( .

Now, select the F4 field which contains the text – Small letters > go back to the new column > close the bracket > looks like this > =lower(F4) > hit Enter. This will convert the “Small letters” to all lower case in the new column.

 

New Column Type = Lower( Select Small Letters Go Back To New Column Enter

 

Step 11. Now follow the same process from Step 4 to Step 7 to convert text to lower case.

 

Select Field Small Letters Hit Enter

 

Then follow the same process as Step 8 to Step 9 to delete the column.


ADVERTISEMENT

 

Step 12: To change the case text to Proper case, again follow the same process from Step 1 to Step 2.

Then for Step 3 > in the new column > select the 1st field (here we selected the empty field next to Small letters) > type =proper( .

Now, select the F4 field which contains the text – Small letters > go back to the new column > close the bracket > looks like this > =proper(F4) > hit Enter. This will convert the “Small letters” to all lower case in the new column.

 

New Column Type = Proper( Select Small Letters Go Back To New Column Enter

 

Step 13: Now follow the same process from Step 4 to Step 7 to convert text to proper case.

 

Select Field Small Letters Hit Enter

 

Then follow the same process as Step 8 to Step 9 to delete the column.

ADVERTISEMENT