Convert text to Initial-Case (Capitalizes the first letter in Text) in Excel

PROPER function

Capitalizes the first letter and any other letters in text that follow any character other than a letter in a text string. Converts all other letters in lowercase.

Syntax

PROPER(text)

The PROPER function syntax has the following arguments:

• Text    Required. Text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing the text you want to partially capitalize.

Example:

Type your data in C3 cell

and then type the proper function in cell G3

=PROPER(C3)

Here is the result