PROPER

Syntax

PROPER(<string>)

Description

Capitalizes the first letter in each word of a text value.

Examples

Column1PROPER returns
datameer is coolDatameer is Cool
testTest
good morningGood Morning
=PROPER(#Sheet1!B)returns each string with the first letter in each word capitalized
=PROPER("test") returns "Test"