We have two options to do it, i. We will see it one by one. So, in the above example, we want the proper data in the cell address E6, hence clicked on this cell. We can see that it is highlighted in red. Step 2: Now, we have to go on Formulas in the top ribbon and then click on Text. Below is the picture for reference:. Below is the picture:.
Step 5: Now, we have to put the cell address in the above blank box. It means, as per the formula, we have to enter the Text parameter, so it is the cell address for which we want to apply the PROPER function.
So, in E6, the text is written in a proper format. We can see the first letter of each word is in uppercase, and the rest is in lowercase. For example, let's say your company wants to give someone a lifetime achievement award. You've asked your coworkers to enter their nominations for the award into this spreadsheet:. Unfortunately, you can see that not everyone has been careful to capitalize the first and last names of the people they want to nominate, so the spreadsheet looks messy.
You could go through the column and correct the names manually, but using the PROPER function will be faster and easier. In this example, the names of the nominees are in column A, so we'll put our formula in column B. In cell B2 , we'll type a formula that tells Excel to capitalize the name in cell A2 , which contains the first name on our list. The formula will look like this:. How do I make sure it stays? Best Excel Shortcuts. Conditional Formatting. Creating a Pivot Table. Excel Tables. Creating a Drop Down List.
Recording a Macro.
0コメント