The Microsoft Excel spreadsheet program has several functions to keep your text case case consistent. If you have a series of names in lowercase, use the “flash fill” function to capitalize the names in Excel 2013. If you want all text in uppercase, use the UPPER function to capitalize all letters or PROPER to capitalize only the first letter.
Step
Method 1 of 4: Using the Capital Letter Function
Step 1. Type a series of names or text in the fields of your worksheet
Your text can be upper or lower case when using this function. The function will convert the text in the cell entirely to uppercase.
Step 2. Add a column to the right of the text field
Click on the letter above the text field. Right-click and select “Insert.”
Step 3. Move the cursor in the cell to the right of the first data you want to capitalize
You will put a formula with a capital letter function into a cell.
Step 4. Press the function key above the toolbar (toolbar)
This button is a blue epsilon and looks like the letter “E.” The formula bar (fx) will be highlighted so you can type functions in it.
Step 5. Select the text function labeled “UPPER” or type the word “UPPER” next to the equals sign in your formula bar
When you press the function key, the word “SUM” may appear automatically. If so, replace “SUM” with “UPPER” to change the function
Step 6. Type the location of the cell in the brackets next to the word UPPER
If you use the first column and row of your data, the function bar will say “=UPPER(A1).”
Step 7. Press “Enter.” Text in A1 will appear in B1 but entirely in uppercase.
Step 8. Click your cursor on the small square in the lower right corner
Slide the box to the bottom of the column. This will fill the series so that each cell of the first column is copied to the second column in uppercase.
Step 9. Check all the text that has been copied correctly into the second column
Highlight the column above the correct text in the letter above the column. Click on the “Edit” menu and click on “Copy”, then click on the “Edit” drop-down menu and select “Paste Values”.
This process allows you to replace formulas with values so that you can delete the text in the first column
Step 10. Check for the same text that reappears in the column
Delete the first column by right-clicking the letter above the column. Select Delete on the drop down menu.
Method 2 of 4: Using Function Name
Step 1. Enter text into the first column of your worksheet
This function will help you capitalize the first letter of the text in each cell.
Step 2. Add a new column
Right-click on the letter heading in the first column. Select “Insert” in the drop down menu.
Step 3. Move the cursor to the cell to the right of the first text entry
Click the formula button. This button is the epsilon symbol above the horizontal toolbar.
Step 4. Click the formula bar
This bar is a question bar next to the “fx” mark just above your worksheet. Type the word "PROPER" after the equal sign.
If the word “SUM” automatically appears in the formula bar, replace it with the word “PROPER” to change the function
Step 5. Type the location of the first cell of your text in brackets next to the word "PROPER
"For example, the text that appears is “=PROPER(A1) ".
Step 6. Press “Enter.” The first letter of each word in the cell is capitalized in the column to the right of the original text. The rest will be in lowercase.
Step 7. Hold down the square in the lower right corner of the cell
Swipe down until you are at the bottom of the original text field. Release the mouse, and all text will be copied with the first letter capitalized.
Step 8. Click on the letter above the replacement column to select the entire column
Click the “Edit” menu and select “Copy.” After that, click the drop-down menu on the Paste button and select “Paste Values.”
The formula-based cells will be replaced with text so you can delete the first column
Step 9. Right click on the first column
Select “Delete” to delete the column and leave the replacement value with the appropriate capitalization.
Method 3 of 4: Using Flash Fill in Excel 2013
Step 1. Use this section if your series is a list of people's names
The name must be written in lowercase in Excel to use this method. The flash fill function can read and convert names so that the first letters of the first and last names are capitalized.
Step 2. Complete your list of names using lowercase letters
Enter in a single column. Leave the column blank to the right of the list of names.
If you don't have a blank column to the right of your list of names, right-click on the lettered column above your list of names. select “Insert” and a new blank column will appear on the right
Step 3. Click on the cell to the right of the registered first name
For example, if your first lowercase name is in cell A1, go to cell B1.
Step 4. Type the same name as cell A1, but include the appropriate capitalization of the first and last names
For example, if the first cell contains "adam malik," type "Adam Malik" in the cell to the right of it. Press “Enter”.
Step 5. Go to the “Data” menu and select “Flash Fill. " This function will learn patterns and make similar changes in the data series, you can also use the shortcut code, " Control " and the letter "E" to activate Flash Fill.
Step 6. Delete the column containing the lowercase names
To prevent duplication, click at the top of the original lowercase column. Right-click and press “delete” to delete and leave the list that is case-sensitive.
Make sure Flash Fill is working on your entire list before removing the original column
Method 4 of 4: Using Word
Step 1. Ways other than Excel formulas to quickly change case letters are as follows:
Step 2. Open a blank Word document
Step 3. In Excel, highlight the cell you want to change the case for
Step 4. Copy the cells (ctrl+C)
Step 5. Paste (paste) on the Word document
(ctrl+V).
Step 6. Highlight all the text in the Word document
Step 7. Click on the “Change Case” drop-down menu on the “Home” label
Step 8. Select the desired option:
Sentence case, lowercase, UPPERCASE, Capitalize Each Word, tOGGLE cASE.
Step 9. Once the changes are applied, highlight all the text and paste it back into Excel
