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
