How to Change from Lowercase to Uppercase in Excel

Four Methods:Using the Uppercase FunctionUsing the Proper Name FunctionUsing Flash Fill in Excel 2013Using WordCommunity Q&A

Microsoft’s Excel spreadsheet program has several functions to make your text type-case consistent. If you have a series of names that is in the lowercase, you can use “flash fill” function to capitalize names in Excel 2013. If you need all the text to be uppercase, you can use UPPER function to capitalize all the letters or PROPER to capitalize the first letter.

Method1

Using the Uppercase Function

1. 
   1
   Type in a series of names or text in a column in your worksheet. Your text can be in any case when using this function. It will change the text in the cell to all uppercase letters.
2. 
   2
   Add a column to the right of your text column. Click on the letter on the top of the text column. Right click and select “Insert.”
3. 
   3
   Move your cursor into the cell to the right of the first data you want to capitalize. You will place a formula with the uppercase function in this cell.
4. 
   4
   Press the function button in the top toolbar. It is a blue epsilon symbol and looks like the letter “E.” The formula bar (fx) will be highlighted so that you can type in your function.
5. 
   5
   Select the text function labeled “UPPER” or type in the word “UPPER” next to the equals sign in your formula bar.

   • When you press the function button, the word “SUM” may automatically appear. If this happens, replace “SUM” with “UPPER” to change the function.^[1]
6. 
   6
   Type the cell location in parenthesis next to the word UPPER. If you were using the first column and row for your data, your function bar would read “=UPPER(A1).”
7. 
   7
   Press “Enter.” The text in cell A1 should appear in cell B1 in all-uppercase letters.
8. 
   8
   Click your cursor on the little box in the bottom right corner of the cell. Drag the box to the bottom of the column. This will fill in the series so that each cell in the first column is copied to the second column in the uppercase.
9. 1. 
      9
      Check that all of the text has been correctly copied into the second column.Highlight the column above the correct text by clicking on the letter above the column. Click on the “Edit” menu and click “Copy,” and then click the “Edit” drop down menu and select “Paste Values.”

      • This process will allow you to replace the formula with the value, so that you can delete the first column of text.
   2. 
      10
      Check that the same text reappears in the column. Delete the first column by right clicking the letter above the column. Select “Delete” from the drop down list.

   Method2

   Using the Proper Name Function

   1. 
      1
      Enter your text into the first column of your spreadsheet. This function will help you to capitalize the first letter of your text in each cell.
   2. 
      2
      Add a new column. Right click on the letter heading the first column. Select “Insert” in the drop down menu.
   3. 
      3
      Move your cursor to the cell to the right of the first text entry. Click the formula button. This is the blue epsilon symbol in the top horizontal toolbar.
   4. 
      4
      Click on the formula bar. It is a query bar next to the “fx” sign just above your spreadsheet. Type the word “PROPER” after the equals sign.

      • If the word “SUM” automatically appeared in the formula bar, replace it with the word “PROPER” to change the function.
   5. 
      5
      Type the first cell location of your text in parenthesis next to the word “PROPER.” For example, it should read “=PROPER(A1).”
   6. 
      6
      Press “Enter.” The first letter of each word in the cell should be capitalized in the column to the right of the original text. The rest of the text will be lowercase.^[2]
   7.