How to Convert Lowercase to Uppercase in Excel

Buzz

Ngày cập nhật gần nhất: 1/12/2025

Content

Steps

Using the Capitalization Function

Using the Proper Noun Function

Using the Flash Fill Feature in Excel 2013

Using Word

Tips

What You Need

Microsoft Excel's spreadsheet software includes various functions to ensure consistent text capitalization. If you have a list of names in lowercase, you can utilize the 'flash fill' feature in Excel 2013 to capitalize them. For converting entire text to uppercase, the UPPER function capitalizes all letters, while the PROPER function capitalizes the first letter of each word.

Steps

Using the Capitalization Function

Enter the list of names or text into a column in the spreadsheet. The text can be in any case, as the function will convert all text in the current cell to uppercase.

Insert a column to the right of the text column. Click on the letter at the top of the next column. Right-click and select 'Insert.'

Move the cursor to the cell on the right of the first data entry you want to capitalize. This is where you will input the capitalization formula.

Click on the function button in the toolbar above. It is the blue epsilon symbol, resembling the letter 'E.' The formula bar (fx) will be selected, allowing you to enter the function.

Select the text function named 'UPPER' or type 'UPPER' after the equals sign in your formula bar.

When clicking the function button, 'SUM' might appear automatically. If so, replace 'SUM' with 'UPPER' to change the function.

Enter the cell reference within parentheses immediately after 'UPPER.' If you are using the first column and row for your data, your formula will be '=UPPER(A1).'

Press the 'Enter' key. The text from cell A1 will appear in cell B1, with all letters converted to uppercase.

Click on the small box at the bottom-right corner of the cell. Drag it down to the end of the column. This will fill the column so that the data from each cell in the first column is copied to the second column in uppercase.

Verify that all text has been accurately copied to the second column. Select the column with the correctly formatted text by clicking the letter at the top of the column. Right-click to open the 'Edit' menu and choose '.' Then, right-click again and from the dropdown 'Edit' menu, select 'Paste Values.'

This step allows you to replace the formula with the actual values, enabling you to delete the first text column without affecting the data in the second column.

Ensure that the identical text appears in the column. Delete the first column by right-clicking the letter at the top of the column. Select 'Delete' from the dropdown list.

Using the Proper Noun Function

Enter the text into the first column of the spreadsheet. This function will capitalize the first letter of the text in each cell.

Add a new column. Right-click the letter at the top of the first column. Select 'Insert' from the dropdown menu.

Move the cursor to the cell to the right of the first text entry. Click the formula button. It is the blue epsilon symbol on the horizontal toolbar at the top.

Click on the formula bar. This is the query bar next to the 'fx' symbol above your spreadsheet. Type 'PROPER' after the equals sign.

If 'SUM' appears automatically in the formula bar, replace it with 'PROPER' to change the function.

Enter the cell reference of the first text entry within parentheses after 'PROPER.' For example: '=PROPER(A1)'.

Press the 'Enter' key. The first letter of each word in the cell will be capitalized in the column to the right of the original text. The rest will remain in lowercase.

Hold the box at the bottom-right corner of the cell. Drag it down to the last row of the original text column. Release the mouse, and the entire text will be copied with the first letter of each word capitalized.

Click the letter at the top of the replacement column to select the entire column. Click the 'Edit' menu and choose '.' Next, click the dropdown menu on the Paste button and select 'Paste Values.'

Cells containing formula-generated values will be replaced with text, allowing you to delete the first column.

Right-click the first column. Select 'Delete' to remove it, leaving the replacement values with the first letter of each word capitalized.

Using the Flash Fill Feature in Excel 2013

Use this section when your list consists of proper names. To utilize it, the original list must be in lowercase. The Flash Fill feature can interpret and modify names so that the first letter of both the first and last names is capitalized.

Complete your list of names by ensuring all letters are in lowercase. Enter them into a single column. Leave an empty column to the right of the name list.

If there is no empty column to the right of the name list, right-click the letter at the top of the name column. Select 'Insert,' and a new empty column will appear to the right.

Click the cell to the right of the first name in the list. For example, if the first lowercase name is in cell A1, you will select cell B1.

Re-enter the name from cell A1 but capitalize the first and last names correctly. For instance, if the first cell contains 'nguyễn an,' type 'Nguyễn An' in the cell to the right. Press the 'Enter' key.

Go to the 'Data' menu and select 'Flash Fill.' Excel will recognize the pattern in the first cell and apply the same changes to the entire data series. You can also use the shortcut 'Control' + 'E' to activate Flash Fill.

Delete the lowercase column. To avoid duplication, click the letter above the original lowercase column. Right-click and select 'Delete' to remove the column, leaving only the capitalized list.