Capitalize the first letter in Excel is very easy and you have 3 tools to do that
- By formula
- With Power Query
- With VBA

Capitalize the first letter by formula
To capitalize the first letter of each word in your cells by formula, just write the PROPER function
=PROPER(B2) or =PROPER([@columnName])



But the job isn't finished 🤔
You must also transform the result of the formula into values with the tool copy/paste special (option values)



Capitalize the first letter with Power Query
If you build a query to manipulate your data with Power Query, you can quickly capitalize the first letter of a column.
- Select one or more columns
- Right-click in the header of the columns
- Go to Transform
- Capitalize each word



This technique is much better because you don't duplicate the contain of your column. The transformation remplaces the previous contain of the column.
Capitalize the first letter with VBA
In VBA, the code to transform your string is the following possible with the instruction StrConv and the option vbProperCase
Sub Capitalize_First_Letter()
Dim MyText As String
Dim i As Long
For i = 2 To 11
Cells(i, 2) = StrConv(Cells(i, 2), vbProperCase)
Next
End Sub
19/11/2021 @ 04:13
I would suggest not using the StrConv's vbProper method, rather, use WorksheetFunction.Proper instead.. Here are the two methods acting on the same text string... the Worksheet function method appears to be more robust (compare the output inside the parentheses and you will see what I mean).
MsgBox StrConv("Here is (one-type of) problem.", vbProperCase)
MsgBox WorksheetFunction.Proper("Here is (one-type of) problem.")