Description
Use this function to capitalize the first letter of each word in a text string, while converting all other letters to lowercase. Supported in Chains.
PROPER is useful for standardizing text data to ensure consistency in text presentation and formatting.
Syntax
PROPER(text)
Inputs
This function accepts the following arguments:
| Name | Required | Description | Valid input |
|---|---|---|---|
text |
Yes | The text string that you want to convert to proper case. (Initial Capitals) | A text string, a reference to a cell containing text, or a formula which results in either of these. |
Example
Sample data
| A |
|---|
| workiva, inc. |
| 2100 university ave. |
| CArbon |
| mIXed Case |
Sample Formulas
| Formula | Description | Result |
|---|---|---|
=PROPER(A1) |
Converts the text in cell A1 to proper case. | Workiva, Inc. |
=PROPER("Nottingham CASTLE") |
Converts the string "EXCEL FUNCTION" to proper case. | Nottingham Castle |
=PROPER(A2) |
Converts the text in cell A2 to proper case. | 2100 University Ave. |
=PROPER("mIXed Case") |
Converts the string "mIXed Case" to proper case. | Mixed Case |
=PROPER(CONCATENATE(A3," by ",A1)) |
Joins the text in cell A3 with the text in cell A1, and converts the joined text to proper case. | Carbon by Workiva, Inc. |
Notes
- PROPER doesn't change any non-text characters within the string.
- PROPER can be used with other functions to ensure text consistency in data presentation.
- PROPER capitalizes the first letter of each word and converts all other letters to lowercase.
Tips
- PROPER can be combined with other text functions such as UPPER and LOWER to manipulate text case as needed.
- PROPER can help create standardized data formats, which is useful in data validation and cleanup tasks.
- Use PROPER to prepare text data for consistent formatting in reports and presentations.
Related functions
CHAR
CODE
CONCATENATE
CONCATENATEIF
FIND
LEFT
LEN
LOWER
MID
PROPER
REPT
RIGHT
SEARCH
SUBSTITUTE
TEXT
TEXTJOIN
TRIM
UNICHAR
UNICODE
UPPER