How To Change Small Letter To Capital Letter In Excel (2020)

November 7, 2020 1:23 pm

Excel is one of the finest programs offered by Microsoft for easy documentation and data analysis. Excel is a combination of rows and columns. In Excel, there are three most common ways to change the case to Uppercase, lowercase, and proper case.

These three ways include using formulas, flash fill, and using Word. All these methods are unique in their approach, and you can select the one convenient for you. It is regarded as one of the best spreadsheet documentation programs and is used quite extensively worldwide.

To understand the methods in excel, it is essential to follow the procedure step by step as a single mistake might end the operation, and you will have to do it from the start again.

All three methods mentioned above have their advantages and disadvantages. If you are new to Excel, it is best to try out all the three methods mentioned and then choose the most reliable way out of the three.

This will ensure that you know all the available methods and can use them as per your requirements. Ensure you follow every step to get the best results.

Method 1: Using Formulas

The procedure of changing any cell in the upper case format is known as Upper Function. Using the formula is a straightforward method as it requires you to feed the formulas to get your work done.

Ensure you insert the right formulas, as mentioned below, for the best results. To change the desired column into the Upper case format, you need to do the following:

Changing Case in Excel: Lower, Upper, Proper

Upper Case

1
Start with inserting a new column beside the one you are willing to change into the upper case.
2
After this, you need to enter the formula in the adjacent column that you just created. The formula for changing into the upper case is =UPPER along with the cell reference. For example, we take the cell as C4, then the formula to change will be =UPPER (C4).
3
After putting in the formula in the adjacent column, hit enter, and the word in the Cell4 will automatically change into uppercase.

Lower Case

1
The lower case procedure is similar; we only need to change the formula.
2
Start with inserting a new column beside the one you are willing to change into the lower case.
3
After this, you need to enter the formula in the adjacent column that you just created. The formula for changing into the lower case is =LOWER, along with the cell reference. For example, we take the cell as C4, then the formula to change will be =LOWER (C4).
4
After putting in the formula in the adjacent column, hit enter, and the word in the Cell4 will automatically change to the lowercase.

Proper Case

1
The proper case procedure remains the same; we need to change the formulas.
2
Start with inserting a new column beside the one you are willing to change into the proper case.
3
After this, you need to enter the formula in the adjacent column that you just created. The formula for changing into the proper case is =PROPER, along with the cell reference. For example, we take the cell as C4, then the formula to change will be =PROPER (C4).
4
After putting in the formula in the adjacent column, hit enter, and the word in the Cell4 will automatically change to the proper case i.e. only the first alphabet of the name and title changes to uppercase and the rest remains the same.

Method 2: Using Flash Fill Method

Flash fill is another method that can be used to change the alphabet cases inserted in the columns. Flash Fill was introduced in the year 2013 to support Excel programs that are of 2013 or older.

In case you are using Excel older than 2013, it is advised to update the latest version to get started with the Flash Fill method. To ensure you do it the right way, follow the directions mentioned below.

How to Use Flash Fill

Upper Case

1
To get started, ensure you have letters already typed in a single column.
2
Once the letters are written, you then require adding a blank column beside the mentioned column. In case you don't have a blank column beside the one you want to edit, then right-click on the mouse on the top of the column, which is to be edited and choose insert. Doing this will provide you with a new column just beside the one you want to edit.
3
The next step will require you to click on the cell that you just created and mention the exact name, which is first in the list in the upper case format. For example, if your first letter is in the A1 cell, you need to write the exact requirement in cell B1.
4
Once the letter is written in the upper case, you need to go to the data which is present in the Menu. From the data, choose Flash Fill.
5
Once you click Flash Fill, it will automatically learn the pattern and fill the entire column as per the first letter you mentioned. To activate Flash Fill, you can also use a shortcut by pressing Ctrl and E simultaneously.
6
Now that you have the letters per your requirement, you need to delete the column with letters in the lowercase. Always ensure that the flash fill has worked on the entire list before deleting the old column.

Lower Case

1
To get started, ensure you have letters already typed in a single column.
2
Once the letters are written, you then require adding a blank column beside the mentioned column. In case you don't have a blank column beside the one you want to edit, then right-click on the mouse on the top of the column, which is to be edited and choose insert. Doing this will provide you with a new column just beside the one you want to edit.
3
The next step will require you to click on the cell that you just created and mention the exact name, which is first in the list in the lower case format. For example, if your first letter is in the A1 cell, you need to write the exact requirement in cell B1.
4
Once the letter is written in the lower case, you need to go to the Menu data on top. From the data, choose Flash Fill.
5
Once you click Flash Fill, it will automatically learn the pattern and fill the entire column as per the first letter you mentioned. To activate Flash Fill, you can also use a shortcut by pressing Ctrl and E simultaneously.
6
Now that you have the letters per your requirement, you need to delete the column with letters in the lowercase. Always ensure that the flash fill has worked on the entire list before deleting the old column.

Proper Case

1
To get started, ensure you have letters already in a single column.
2
Once the letters are written, you then require adding a blank column beside the mentioned column. In case you don't have a blank column beside the one you want to edit, then right-click on the mouse on the top of the column, which is to be edited and choose insert. Doing this will provide you with a new column just beside the one you want to edit.
3
The next step will require you to click on the cell that you just created and mention the exact name, which is first in the list in the proper case format. For example, if your first letter is in the A1 cell, you need to write the exact requirement in cell B1.
4
Once the letter is written in the proper case, you need to go to the data present in Menu. From the data, choose Flash Fill.
5
Once you click Flash Fill, it will automatically learn the pattern and fill the entire column as per the first letter you mentioned. To activate Flash Fill, you can also use a shortcut by pressing Ctrl and E simultaneously.
6
Now that you have the letters per your requirement, you need to delete the column with letters in the lowercase. Always ensure that the flash fill has worked on the entire list before deleting the old column.

Using Word

Using Word is the easiest way to change letters into uppercase, lowercase, and proper case. The procedure involved here is between two programs of Microsoft, which are Excel and Word.

This is the shortest one and one of the most reliable. You will need to open a blank Word document side by side to get started with this method. If you have not installed Microsoft's word program, it is advised you first install it for the best results. Make sure you follow all steps mentioned below one by one for the best result.

Upper Case

1
To start, you will require first to open a blank word document.
2
Now, go back to Excel and highlight the cell that you are looking forward to changing in the Upper Case.
3
After highlighting the cell, copy it by pressing Ctrl and "C."
4
Paste the copied cell in the Word document.
5
Once pasted in the word document, you will then require highlighting the entire text.
6
Now go to the Home tab and select the change case. Once there, choose the uppercase format. Once done, you will notice all the letters have changed into the uppercase format.
7
After it has changed, highlight the entire text and copy it, and then paste it back in the cell of your Excel sheet.

Lower Case

1
To start, you will require first to open a blank word document.
2
Now, go back to Excel and highlight the cell that you are looking forward to changing in the Lower Case.
3
After highlighting the cell, copy it by pressing Ctrl and "C."
4
Paste the copied cell in the Word document.
5
Once pasted in the Word document, you will then require highlighting the entire text.
6
Now go to the Home tab and select the change case. Once there, choose the Lowercase format. Once done, you will notice all the letters have changed into the lowercase format.
7
After it has changed, highlight the entire text and copy it, and then paste it back in the cell of your Excel sheet.

Proper Case

1
To start, you will require first to open a blank word document.
2
Now, go back to excel and highlight the cell that you are looking forward to changing in the Proper Case.
3
After highlighting the cell, copy it by pressing Ctrl and "C."
4
Paste the copied cell in the Word document.
5
Once pasted in the Word document, you will then require highlighting the entire text.
6
Now go to the Home tab and select the change case. Once there, choose the Proper case format. Once done, you will notice all the letters have changed into the proper case format.
7
After it has changed, highlight the entire text and copy it, and then paste it back in the cell of your Excel sheet.

Conclusion

All three methods mentioned above have their specialties and can be used as per requirements. Always ensure you meet the conditions, such as the Excel version and Microsoft word program to get started.

These methods are tested well in advance and written most straightforwardly to offer a solution to many users worldwide. Try out these cool methods to get your excel work done instantly.

Piyush

Follow me here

Share0

Tweet0

Share0

About the Author

Piyush Kashyap is a Ph.D student at Sant Longowal Institute of Engineering and Technology, Sangrur. He is a budding editor/ writer and has been working as a part-time reviewer for online content. He loves to read tech-based articles and has a knack for reviewing such articles He likes to stay updated about the latest trends in technology. He has also been working as a reviewer for many scientific journals. He also writes articles based on science. Know More About Piyush

Learn more