PROPER Function
Written by kazamraza
no comments
Classified in : Excel Formulas, Text Functions
Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters.
Syntax
PROPER(text)
text is your cell reference
The PROPER function syntax has the following arguments:
- Text Required. Text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing the text you want to partially capitalize.
| ◢ | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Data | Formula | Result | ||
| 2 | this is a TITLE | =PROPER(A2) | This Is A Title | ||
| 3 | KaZaM RaZa | =PROPER(A3) | Kazam Raza | ||
| 4 |