![]() Then click button to run the code, then a dialog is displayed for you to select a range, see screenshot:Ĥ. Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8) Then click Developer > Visual Basic, a new Microsoft Visual Basic for applications window will be displayed (or you can press the shortcut keys Alt + F11 to open the window), then click Insert > Module, and input the following code into the Module: Sub ProperCase() Active the worksheet that you want to use.Ģ. ![]() Note: As they are formulas, when you copy and paste them, you need paste them as values.ġ. And all of the upper case text has been converted to the proper case. Then press Enter key, select cell B2, and drag the fill handle over the range that you want to contain this formula. In the adjacent blank cell B2, enter this formula: =PROPER(A2), see screenshot:Ģ. Microsoft Excel's Proper function can change any text to proper cases. And this article will guide you to change all uppercase letters or text strings to proper case or title case in Microsoft Excel.Ĭhange uppercase to proper/title case in Excel with PROPER functionĬhange uppercase to proper/title case in Excel with VBA codeĬhange uppercase to proper/title case in Excel with Kutools for Excel Sometime you may need to change uppercase letters to title case or proper case as following screenshot shown. How to change uppercase to proper or title case in Microsoft Excel?
0 Comments
Leave a Reply. |