Home > Microsoft Office > Excel > Change Uppercase to Proper Case - Excel
Change Uppercase to Proper Case - Excel
If a column of names is in all UPPER case but you need it in Proper case, instead of retyping everything, add a column, write a function that changes the data. The function is =PROPER(cell address.
This process also works in Excel 2013 & 2010.
Step 1:
Insert a column to make room for the function. Point to the column immediately to the right of the all uppercase column. Right click on the column letter and choose Insert.
Step 2:
Title the new column, for example, Name.
Step 3:
Select the first empty cell in the new column.
Step 4:
Type: =proper(

Step 5:
Click on the cell immediately to the left which contains the all uppercase text. This writes the cell address for you.
Step 6:
Press Enter. The function displays text in proper case.
Step 7:
Copy the function down the column.
More information in Excel Help:
Click the ? or press F1 for help. Search for "Change the case of text." This Microsoft article describes the Proper function in detail.
Author: kelliek | Last Updated: 3/26/2018 11:57 AM | Page Views: 2072 |
helpdesk.etown.edu/helpconsole2012/kb/default.aspx?pageid=change_uppercase_to_proper_case
|