PROPER
- Charles Bishop (Deactivated)
Owned by Charles Bishop (Deactivated)
Jan 30, 2018
Loading data...
Syntax
PROPER(<string>)
Description
Capitalizes the first letter in each word of a text value.
Examples
| Column1 | PROPER returns |
|---|---|
| datameer is cool | Datameer is Cool |
| test | Test |
| good morning | Good Morning |
=PROPER(#Sheet1!B)returns each string with the first letter in each word capitalized
=PROPER("test") returns "Test"