Change Uppercase To Proper/Title Case In Excel With PROPER Function
Microsoft Excel's Proper function can change any text to proper cases. Please do as this:
1. In the adjacent blank cell B2, enter this formula: =PROPER(A2), see screenshot:
2. Then press Enter key, select cell B2, and drag the fill handle over the range that you want to contain this formula. And all of the upper case text has been converted to the proper case. See screenshot:
Note: As they are formulas, when you copy and paste them, you need paste them as values.