Q:

How can i force capitalization of first letter of each word in Excel cell

I'm working on a simple Excel sheet, where users enter their first name, sometimes they don't use capital letters, so I'm trying to make the name cells capitalize first letter automatically when they fill in their name.
I tried PROPER formula but this is useful between 2 cells / columns.
When a user Enter "jose gonzalez" in the name cell and hit enter, the content become "Jose Gonzalez".

A:

Using the VBA editor (Alt + F11) in the Sheet module that you're working on, paste the following code
Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Count > 1 Then
'more than one cell
Else
    If Target.Column = 5 Then
        If Len(Target) > 0 Then
            Application.EnableEvents = False
            Target = Application.WorksheetFunction.Proper(Target)
            Application.EnableEvents = True
        End If
    End If
End If
End Sub

Mine is using column E which is 5 so you would need to adjust accordingly.

