I. Intro
The PROPER function converts the first letter of each word in a character string to uppercase, and other letters to lowercase.
To use this function, enter =PROPER in a cell, or click Menu > Data > Formulas > Text > PROPER in the toolbar. Enter the arguments and press Enter.
II. About the function
Formula: =PROPER(text_to_capitalize)
Arguments:
- text_to_capitalize (required): The text that you want to convert.
Example: =PROPER("this is a test") will return This Is A Test.
III. Use cases
Standardize text
When your text data doesn't have the right capitalization, such as a list of names all in lowercase, you can use this function to quickly format the whole data set.
Formula used in the screenshot below: =PROPER(CONCATENATE(A8," ",B8))
About the formula:
Two formulas are used as a set here.
- First, the CONCATENATE function links the surnames and names together. The " " in the formula is used to add a space between the surname and first name.
- The PROPER function capitalizes the first letters in the names and surnames.
250px|700px|reset