The PROPER function
Capitalizes the first letter of each word and makes the rest small.
Syntax
PROPER(text)- text
- The text to convert.
Examples
C1=PROPER(A2)
| A | B | C | |
|---|---|---|---|
| 1 | Name | Anna Berg | |
| 2 | anna berg |
C1=PROPER("JENS HANSEN")
| A | B | C | |
|---|---|---|---|
| 1 | Name | Jens Hansen | |
| 2 | anna berg |