PROPERformula capitalizes the first letter of each word in a given text string. This formula is commonly used to format names and titles.
- How to use
- Examples of using
PROPERformula not working?
- Similar formulas to
PROPER formula with the syntax shown below, it has 1 required parameter:
- text_to_capitalize (required):
The text string that you want to capitalize the first letter of each word.
ExamplesHere are a few example use cases that explain how to use the
PROPERformula in Google Sheets.
PROPER formula can be used to format names in a list so that each name is capitalized correctly.
PROPER formula can be used to format titles in a list so that each title is capitalized correctly.
Creating a greeting
PROPER formula can be used to create a greeting in a cell based on the name entered in another cell.
PROPERnot working? Here are some common mistakes people make when using the
PROPERGoogle Sheets Formula:
Not Including Text String
One common mistake when using
PROPER is forgetting to include the text string parameter.
Capitalizing All Letters
Another common mistake when using
PROPER is expecting the formula to capitalize all letters in the text string.
The following functions are similar to
PROPER or are often used with it in a formula:
UPPERformula in Google Sheets converts all the letters in a given text string to uppercase. It takes one required argument, the
textto convert. This formula is commonly used to standardize text data or to make it easier to compare text values.
LOWERformula converts all letters in a specified text string to lowercase. It takes one required parameter, which is the text string to be converted. This formula is commonly used to standardize text data for easier analysis and comparison.
The CONCATENATE function in Google Sheets is used to combine text strings from different cells or inputted directly in the formula. It takes one or more text strings as input and returns a single concatenated string. This function is commonly used to combine first and last names, or to merge data from multiple cells into a single cell.
You can learn more about the
PROPER Google Sheets function on Google Support.