PROPER
Syntax
PROPER(<string>)
Description
Capitalizes the first letter in each word of a text value.
Examples
| Column1 | PROPER returns |
|---|---|
| datameer is cool | Datameer X 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"