PROPER

Capitalizes the first letter in all the words of a text string.  Converts all other letters to lowercase letters.

Sample Usage

PROPER("AbiLity")
PROPER("PhySical abiLITY")
PROPER(C5)

Syntax

PROPER(text)

  • text - The text to be converted. 

 

Examples

PROPER("AbiLity") returns the formatted text: "Ability". 
PROPER("PhySical abiLITY") returns the formatted text: "Physical Ability". 
PROPER(C5) takes it's input from C5 and returns formatted text.