It is possible to make your text type-case consistent with the many functions in Microsoft's excel spreadsheet program.If you have a bunch of names that are in the lower case, you can use the flash fill function to capitalized them in excel.If you need the text to be capitalized, you can use the UPPER function to do it.
Step 1: You can type in a series of names or text in the column in your worksheet.
When using this function, your text can be in any case.The text in the cell will be changed.
Step 2: You can add a column to the text column.
The letter is on the top of the column.Click and select the option to insert.
Step 3: To get to the first data you want to exploit, you need to move your cursor into the cell.
There is a formula in this cell.
Step 4: The function button is located in the top toolbar.
The symbol looks like the letter E and the formula bar will be highlighted so that you can type in your function.
Step 5: If you want to type in the word "UPPER" next to the equals sign in your formula bar, you have to select the text function labeled "Upper".
The word "SUM" may appear when you press the function button.To change the function, replace "SUM" with "UPPER"
Step 6: The word UPPER is next to the cell location in parentheses.
If you were using the first column and row for your data, your function bar would read "UPPER(A1)."
Step 7: Press the enter button.
In all-uppercase letters, the text in cell A1 should appear.
Step 8: The little box in the bottom right corner of the cell is where you can click your cursor.
The box should be at the bottom of the column.The series will be filled in so that each cell in the first column is copied to the second.
Step 9: The text has been copied into the second column.
Click on the letter above the column to highlight it.If you want to remove the first column of text, you need to replace the formula with the value.
Step 10: The same text appears in the column.
Click the letter above the column to remove the first column.From the drop down list, select "Delete".
Step 11: The first column of the spreadsheet contains your text.
The first letter of your text will be capitalized by this function.
Step 12: A new column is added.
The first column has a letter heading it.Go to the drop down menu and select "Insert".
Step 13: The first text entry should be to the right of the cell.
The button has a formula on it.The blue epsilon symbol is in the top horizontal bar.
Step 14: You can click on the formula bar.
There is a query bar next to your spreadsheet.After the equals sign, type the wordPER.To change the function, replace the word "SUM" with "PER" in the formula bar.
Step 15: The first cell location of your text can be found next to the word PROPER.
For example, it should read PROPER.
Step 16: Go to enter.
The column to the right of the original text should have the first letter of each word capitalized.The rest of the text will not be bold.
Step 17: There is a box in the lower right corner of the cell.
When you are at the bottom of your original text column, drag it down the column.The text should have been copied with the first letters capitalized.
Step 18: To select the entire column, click on the letter at the top of your replacement column.
The formula based cells will be replaced with text if you click the drop down menu on the Paste button.
Step 19: You can click on the first column.
Remove it and leave the replacement values with proper cases.
Step 20: If your series has a list of proper names, use this section.
The method will need to be written in the lower case in excel.The first and last names can be capitalized with the flash fill function.
Step 21: You can complete your list of names with lower-case letters.
You can enter them in a single column.To the right of the list of names, leave a blank column.Click on the lettered column above your list of names if you don't have a blank column to the right.A new empty column will appear if you select "Insert"
Step 22: To the right of the first name, click on the cell.
You would go to cell B1 if your first name was in cell A1.
Step 23: The name should be the same as the cell in A1, but the first and last names need to be capitalized correctly.
If the first cell saysjoe biggins, type it in the cell to the right.Press enter.
Step 24: Go to the data menu and select the flash fill.
It will change the data series when it learns the pattern.The short cut code, "Control" and the letter "E" can be used to flash fill.
Step 25: The column needs to be deleted with the names that are not capital letters.
Click on the top of the original column to avoid duplicating.To get rid of it, right click and press "delete", then leave the list with proper cases.It's a good idea to make sure that flash fill works on your whole list before you remove it.
Step 26: An alternative to writing formulas in excel is to change the case very quickly.
Step 27: Go to a blank Word document.
Step 28: You can highlight the cells you want to change.
Step 29: Control "C" allows copying the cells.
Step 30: You can paste it into a Word document.
Step 31: All the text should be highlighted in the Word Document.
Step 32: The "Change Case" menu is in the "Home" tab.
Step 33: Choose the option of capitalizing each word, tOGGLE cASE, or sentence case.
Step 34: When the case has changed, highlight the text and paste it back into excel.
Step 35: The entire process can take a few seconds.