PROPER
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"