If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!
Let’s say that you have a list of names that is in all lower case. Unlike Word, Excel does not have a “Change Case” command. However, you can use the Proper function to capitalize the first letter of each word and then paste the results as a value.
We will assume that the list you want to format is in Column A, beginning in cell A2.
To Change Case in Excel using the Proper function:
- In Cell B2, type: =Proper(A2)
- Copy the formula to the cells below in Column B all the way down to the last item in the list in Column A. The list is now duplicated in column B, with the first letter being capitalized.
- Highlight the cells in Column B and click the Copy icon on the Home Ribbon.
- Right-click on cell B2 and choose “Paste Special” from the contextual menu.
- Click the “Values” radio button from the paste special dialog box. Click OK.
- You can now delete Column A (the column with the original values in lower case)
Similar Posts:
- Converting Formula Results to Values in Excel
- Using the AutoSum Button in Excel
- Transpose Rows and Columns in Excel
- Absolute Cell References in Excel
- Creating a drop-down list in Excel
- Using the Min, Max, Count and Average Functions in Excel
- Setting Default Paste Options in Word 2007
