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