Capitalizes the first letter in the specified text and any other letters that follow a character other than a letter. Converts all other letters to lowercase letters.
Syntax
 Copy Code
|
|---|
PROPER( Text text ) → Text |
Parameters
- text
- Required. The text to capitalize.
Example
| Formula
Copy Code
|
|---|
=PROPER("this is a TEXT") |
See Also
Function Reference
LOWER Function
UPPER Function