Check Sheet Logo
Check Sheet

PROPER

The PROPER formula capitalizes the first letter of each word in a given text string. This formula is commonly used to format names and titles.

Usage

Use the PROPER formula with the syntax shown below, it has 1 required parameter:

=PROPER(text_to_capitalize)
Parameters:
  1. text_to_capitalize (required):
    The text string that you want to capitalize the first letter of each word.

Examples

Here are a few example use cases that explain how to use the PROPER formula in Google Sheets.

Capitalizing names

The PROPER formula can be used to format names in a list so that each name is capitalized correctly.

Formatting titles

The PROPER formula can be used to format titles in a list so that each title is capitalized correctly.

Creating a greeting

The PROPER formula can be used to create a greeting in a cell based on the name entered in another cell.

Common Mistakes

PROPER not working? Here are some common mistakes people make when using the PROPER Google 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.

Related Formulas

The following functions are similar to PROPER or are often used with it in a formula:

  • UPPER

    The UPPER formula in Google Sheets converts all the letters in a given text string to uppercase. It takes one required argument, the text to convert. This formula is commonly used to standardize text data or to make it easier to compare text values.

  • LOWER

    The LOWER formula 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.

  • CONCATENATE

    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.

Learn More

You can learn more about the PROPER Google Sheets function on Google Support.