FLASH SALE! - "CHATGPT AND ARTIFICIAL INTELLIGENCE FOR MICROSOFT EXCEL AT 60% OFF" Enroll Now

Uppercase in Excel

Updated on January 2, 2024
Article byWallstreetmojo Team
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

How to Change Lowercase to Uppercase in excel? (10 Easy Steps)

You can download this Uppercase Excel Template here – Uppercase Excel Template

  1. Select the text data you want to convert in the upper case in Excel. You can choose at least one text cell to convert it.


    Upper case in Excel Example 1.1

  2. 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:


    Upper case in Excel Example 1.2

  3. Enter the formula in both columns to change the text cases: =UPPER(text). This Excel formula is used where you want the text in uppercase only.


    Upper case in Excel Example 1.3

  4. Use cell number in place of text in a column, which means that for which text you want the upper case.


    Upper case in Excel Example 1.4

  5. Press the “Enter” key. You will get the B2 cell text in the upper case. It means that you have correctly made use of your formula.


    Upper case in Excel Example 1.5

  6. Drag the formula in all the rows. You will get the result with all the text versions in upper case only or copy the formula from the first cell to all the cells in a column.


    upper case in excel example 1.6

  7. Once the data is in uppercase, copy it and paste it into the original column to remove the duplicate column you created while using the formula.

  8. Select the column in which you have entered the formula and copy the column of the data.


    Upper case in Excel Example 1.7

  9. Right-click the data and click on the “Values” icon under “Paste Options” in the dialog box menu.


    Upper case in Excel Example 1.8

  10. Paste the value in the original column. Then, delete the duplicate column in which you had to enter the formula to change the text case.


    Upper case in Excel Example 1.9

    Now, you will see the values with all uppercase text in your data.

Advantages

  1. Uppercase in Excel is a very simple formula to use.
  2. It is worked in formulas that are intended to achieve explicit tasks.
  3. It does not affect the other data in the Excel workbook.
  4. It is easy using this function in huge data as well.
  5. Uppercase in Excel is very beneficial when you use the name of the person in your Excel workbooks.
  6. Using the Excel uppercase function in the workbook helps organize and make the data presentable.
  7. It helps to give an upper-case version of a given text in the Excel sheet if you use the upper-case formula punctuation, and numerical values are not affected.

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

Disadvantages

  1. The Excel uppercase function is not built-in in the Excel ribbon toolbar.
  2. We must copy and paste the data from one column to another to use this function.
  3. There is no shortcut key in Excel to use this function.

Things to Remember

  1. When copying the formula cells, we must always paste it in value format only. Otherwise, all the data will be mismatched, giving the wrong result.
  2. We must always add the temporary or duplicate column in your sheet to use this formula because it will help to paste the values in the original column.
  3. Do not forget to delete the duplicate column from the data.
  4. There is no shortcut key to use this function in the Excel workbook.
  5. While inserting the duplicate column, we have two options. First, we can delete or hide the column from the Excel workbook.
  6. When we have imported some text data or copied the data in the Excel worksheet, occasionally, the words have incorrect capitalization or case. E.g., all the text cases are in lower case, which shows that data is not in the correct case. Therefore, it results in a bad presentation of the data.

This article has been a guide to Uppercase in Excel. Here, we discuss converting lowercase text to uppercase in Excel, examples, and a downloadable Excel template. You may learn more about Excel from the following articles: –

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *