How to Capitalize First Letter of Each Word in Excel (4 Ways)

To capitalize the first letter of each word, we are going to use the following dataset, which contains some employee names in column B but in the wrong way. We will correct the name in column C.

Method 1 – Using Excel Flash Fill to Capitalize the First Letter of Each Word

Steps:

Select the entire result range (C5:C10).
Insert the first result value manually. In our example, we put Tom Smith in C5.
Press Ctrl + Enter.

Press Ctrl + E.
This will automatically capitalize all the first letters for each word.

Method 2 – Capitalizing the First Letter of Each Word by Using the PROPER Function

Steps:

Select cell C5.
Insert the following:

=PROPER(B5)

Press Enter.

Drag the Fill Handle down or Double-click on the Plus (+) icon.

You can see all the first letters of each word are now capitalized in column C.

Method 3 – Applying VBA to Capitalize the First Letter

Steps:

Go to the Developer tab from the ribbon.
Click on Visual Basic under the Code category. Alternatively, press Alt + F11.

Another way to display the Visual Basic Editor is to right-click on your worksheet and click on View Code.

This will take you to the Visual Basic Editor.
Click on Module from the Insert drop-down menu.

Copy and paste this VBA code there.

VBA Code:

Sub CapitalizeFirstWord()
Set myRange = Application.Selection
Set myRange = Application.InputBox("Select Range", "CapitalizeFirstWord", myRange.Address, Type:=8)
For Each myCell In myRange
myCell.Value = Application.Proper(myCell.Value)
Next
End Sub