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 |
||
|---|---|---|
1 |
workiva, inc. | |
2 |
2100 university ave. | |
3 |
CArbon | |
4 |
mIXed Case |
Sample Formulas
| Use case | Formula | Explanation and Result |
|---|---|---|
| Standardize a company name to proper capitalization. | =PROPER(A1) |
Capitalizes the first letter of each word in "workiva, inc." and lowercases the rest. Result: Workiva, Inc. |
| Fix a text string typed directly into the formula that's in all caps. | =PROPER("Nottingham CASTLE") |
Capitalizes only the first letter of each word in "Nottingham CASTLE," lowercasing the rest of "CASTLE." Result: Nottingham Castle |
| Standardize an address to proper capitalization. | =PROPER(A2) |
Capitalizes the first letter of each word in "2100 university ave.," leaving the number unaffected. Result: 2100 University Ave. |
| Fix a text string with inconsistent, mixed-up capitalization. | =PROPER("mIXed Case") |
Normalizes "mIXed Case" so only the first letter of each word is capitalized. Result: Mixed Case |
| Combine text from two cells into one phrase with consistent capitalization. | =PROPER(CONCATENATE(A3," by ",A1)) |
Joins "CArbon" and "workiva, inc." with " by " in between, then capitalizes the first letter of every word in the combined string — including "by." Result: 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.