Convert text to Capital-Case (Capitalizes all the letter in Text) in Excel

UPPER function

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

Syntax

UPPER(text)

The UPPER function syntax has the following arguments:

• Text    Required. The Text want converted to uppercase. Text can be a reference or text string

Example:

Type your data in C3 cell

and then type the proper function in cell G3

=PROPER(C3)

Here is the result

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