This is the function button just above your data. The Insert Function window will expand. Select the Text category from the menu.
This displays Excel functions that pertain to handling text. This function converts all letters to uppercase. If you'd rather just capitalize the first character of each part of a name or the first character of each word, if you're working with words , select PROPER instead. Click OK. The Function Arguments window will also appear. Highlight the cells you want to make uppercase. If you want to make everything in the column uppercase, just click the column letter above your data.
A dotted line will surround the selected cells, and you'll also see the range appear in the Function Arguments window. If you're using PROPER, select all of the cells you want to make proper case—the steps are the same no matter which function you're using. Now you'll see the uppercase version of the first cell in your data appear at the first cell of your new column.
Double-click the bottom-right corner of the cell that contains your formula. This is the cell at the top of the column you inserted.
Once you double-click the dot at the bottom of this cell, the formula will propagate to the remaining cells in the column, displaying the uppercase versions of your original column data. If you have trouble double-clicking that bottom-right corner, you can also drag that corner all the way down the column until you've reached the end of your data.
Copy the contents of your new column. For example, if your new column the one that contains the now-uppercase versions of your original data is column B, you'll right-click the B above the column and select Copy. Paste the values of the copied column over your original data. You'll need to use a feature called Paste Values, which is different than traditional pasting. This option will replace your original data with just the uppercase versions of each entry not the formulas.
Here's how to do it: Right-click the first cell in your original data. For example, if you started typing names or words into A1, you'd right-click A1. The Paste Values option might be in a different place, depending on your version of Excel.
If you see an icon with a clipboard that says "," click that to paste the values. If you see a Paste menu, select that and click Values. Expand your skills. Get new features first. A subscription to help make the most of your time. Smart assistance features. Ad-free email. Back up and access files across devices. Try one month free. Was this information helpful? Yes No. Thank you! Use the following formula. Only one cell should be selected to apply the change case functions. When a formula is entered, the hover is displayed by mentioning the purpose of the function.
After entering a formula, the ENTER key should be pressed on the keyboard to have the desired result. Several steps are required to display the text in the required format.
The above figure shows the sample data to convert into a lower case. The formula of the lower function should be entered into the highlighted cell. For example, if you wanted to show in cell B1 an uppercase version of the text in A1, you could type the below function into B1.
Once you've created any of the above formulas, you can use the Excel Fill Handle to copy the function into as many cells as needed. Users who are using Excel and higher also have the option to use Excel Flash Fill to automatically fill cells to how you want them to be formatted.
Below is an example of how Flash Fill can complete text with the case you want to use. Enter the text how you want it to appear.
0コメント