How to change text strings to sentence case in Microsoft Excel?
You may need to change text strings to sentence case in Microsoft Excel. Supposing there are hundreds of text strings in uppercase or lowercase, changing them manually one by one is not a good choice. Are there easy tricks to change text strings to sentence case in Microsoft Excel?
- Change text strings to sentence case in Excel with VBA
- Change text strings to sentence case in Excel with Kutools for Excel
If you are experienced with Microsoft Excel, using VBA is a good choice to change text strings to sentence case.
Step 1: Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.
Step 2: Click Insert > Module, and paste the following macro in the Module window.
Sub SentenceCase() 'Updateby20131127 Dim Rng As Range Dim WorkRng As Range On Error Resume Next xTitleId = "KutoolsforExcel" Set WorkRng = Application.Selection Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8) For Each Rng In WorkRng xValue = Rng.Value xStart = True For i = 1 To VBA.Len(xValue) ch = Mid(xValue, i, 1) Select Case ch Case "." xStart = True Case "?" xStart = True Case "a" To "z" If xStart Then ch = UCase(ch) xStart = False End If Case "A" To "Z" If xStart Then xStart = False Else ch = LCase(ch) End If End Select Mid(xValue, i, 1) = ch Next Rng.Value = xValue Next End Sub
Step 3: Press the F5 key to run this macro, then a dialog is popped up on the screen for selecting a range, see screenshot:
Step 4: Click Ok, and you can see the result as shown as below:
VBA macro may be not easy for starter users of Microsoft Excel. Please do not worry about it. Kutools for Excel's Change Case tool can change all text strings to sentence case in selections quickly.
Step 1: Select the range in which you will change text strings to sentence case.
Step 2: Click the Kutools > Text Tools > Change Case…. See screenshot:
Step 3: In Change Case dialog box, check the Sentence Case. Option, and click OK or Apply button.
Then you will view all kinds of text strings are changed to sentence case in the selection. See the following figure:
Kutools for Excel's Change Case tool can quickly change text case to UPPER, LOWER, PROPER, Sentence Case, and tOGGLE cASE. Click to know more…
- Change case of text 2007 and 2010
- Change text strings to uppercases
- Change uppercase to lowercase
- Change uppercase to proper or title case
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!