Table of Contents
How to Convert to Uppercase in Excel?
Uppercase function in Excel helps you to converts the text to all upper case which capital alphabetically letters. For e.g. month converts to MONTH
Let us take an example to do the same.
- Select the text data which you want to convert in upper case in excel. You can choose at least one text cell to convert it.
- Insert the tab on the left side of the column (Left to the month column) and use the adjacent column for data in the right column:
- Enter the formula in both the Column to change the text cases: =Upper(text). This excel formula is used where you want the text in uppercase only.
- Use cell number in place of text in a column which means that for which text you want the upper case.
- Press Enter, you will get the B2 cell text in upper case. It means that you have correctly made use of your formula.
- Drag the formula in all the rows, you will get the result with all the text version in upper case only or copy the formula from the first cell to all the cells in a column.
- Once the data is in uppercase, copy the data and paste it in the original column to remove the duplicate column which you have created while using the formula.
- Select the column in which you have entered the formula and copy the column or the data.
- Use Right Click on the data, click on Values icon under Paste Options in the dialogue box menu.
- Paste the value in the original column; delete the duplicate column which you have used to enter the formula to change the text case.
Now, you will see the values with all uppercase text in your data.
Advantages of Uppercase in Excel
- Uppercase in excel is a very simple formula to use in excel.
- It is simply worked in formulas that are intended to achieve explicit tasks.
- It does not affect the other data in your Excel workbook.
- It is easy using this function in huge data as well.
- Uppercase in excel is very beneficial when you are using the name of the person in your Excel workbooks.
- Using the excel uppercase function in your excel workbook help you to organize and make your data presentable
- This helps you to give an upper-case version of a given text in your excel sheet if you are using the upper case formula punctuation and numerical values are not affected.
Disadvantages of Uppercase in Excel
- Excel uppercase function is not inbuilt in excel ribbon toolbar.
- To use this function, always need to copy and paste the data from one column to another column.
- There is no shortcut key in excel to use this function in excel.
Things to remember about Uppercase in Excel
- Make sure when you are copying the formula cells, always paste it in value format only otherwise all your data will be mismatched and it gives you the wrong result.
- Always add the temporary or duplicate column in your sheet to use this formula because it will help you to paste the values in your original column.
- Don’t forget to delete the duplicate column from your data.
- There is no shortcut key to use this function in the excel workbook.
- While inserting the duplicate column, have two option you can either delete the column or hide the column from your Excel workbook.
- When you have imported some text data or copied the data in your Excel worksheet, occasionally the words have incorrect capitalization or case. For e.g. all the text case are in lower case which shows that data is not in a correct case and it results in the bad presentation of your data.
You can Download these Uppercase Excel Template here – Uppercase Excel Template
This has been a guide to Uppercase in excel. Here we discuss how to convert lowercase text to Uppercase in excel along with examples and downloadable excel template. You may learn more about excel from the following articles –