How to Convert Text to Title Case in Excel (4 Methods)

Dataset Overview

We’ll use the data set below to demonstrate the methods.

change to title case in excel

Method 1 – Using the PROPER Function

The PROPER function is a handy tool for converting text to title case. It capitalizes the first letter of each word while keeping the rest in lowercase. Follow these steps:

Open your Excel workbook.
Go to cell C5 (where you want the title case output).
Enter the following formula:

=PROPER(B5)

Press ENTER to display the output.

Use Fill Handle to AutoFill the formula down to cell C10.

Method 2 – Applying Excel VBA Macro

For more advanced users, you can use a Visual Basic for Applications (VBA) macro to achieve title case conversion. VBA is the programming language for Microsoft Excel. Here’s how:

Copy the values from cells B5 to B10 (CTRL+C).

Paste them into cells C5 to C10 (CTRL+V).

Press ALT + F11 to open the VBA editor.
Insert a new module (go to Insert > Module).

Enter the following VBA code in the module:

VBA Code:

Sub TitleCase()
Dim R As Range
Dim Rng As Range
On Error Resume Next
xTitleId = "Select Your Range"
Set Rng = Application.Selection
Set Rng = Application.InputBox("Put the Range", xTitleId, Rng.Address, Type:=8)
For Each R In Rng
    R.Value = Application.WorksheetFunction.Proper(R.Value)
Next
End Sub

Press F5 to run the program or use the ribbon to run the subroutine.

An input box will appear; select the range (e.g., C5:C10) and click OK.

Excel will convert the text to title case.

VBA Code Explanation

In the provided VBA code:

We create a subroutine called TitleCase.
Define two variables: R (for iterating through the range) and Rng (to store the selected range).
Use the WorksheetFunction.Proper property to convert each value to title case.

Method 3 – Using PowerQuery

PowerQuery is a powerful tool in Excel that allows you to import, connect to external data sources, and transform your data. Follow these steps to change text to title case using PowerQuery:

Copy the names you want to convert (from B5 to B10) and paste them into cells C5 to C10 (following the method from step 2).
Select the entire table.

Go to the Data tab.
Click From Table/Range.

The Create Table dialog will appear. Check the box if your table has headers, then click OK.

Excel will open the PowerQuery Editor
In the PowerQuery Editor, select the column containing the names (e.g., “converted”).
Go to the Transform tab.
Under Text Column, choose Format and select Capitalize Each Word.