Skip to content
How do you change t...
Clear all

[Sticky] How do you change the uppercase to a proper or title case in Microsoft Excel?

Posts: 49
Topic starter
Joined: 8 months ago

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.

Topic Tags