Spread Formula Reference
Formula Functions / Functions M to Q / PROPER
In This Topic
    PROPER
    In This Topic

    This function capitalizes the first letter in each word of a text string.

    Syntax

    PROPER(text)

    Arguments

    The text argument can be a string, a formula that returns a string, or a reference to a cell containing a string.

    Remarks

    This function capitalizes letters that follow any character other than a letter, for example, a space. This function converts all other letters to lowercase letters.

    Data Types

    Accepts string data. Returns string data.

    Examples

    PROPER(D2)

    PROPER(""INTRO to SPREAD"") gives the result Intro To Spread

    PROPER(""Tom's one-time order"") gives the result Tom’S One-Time Order

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    CHAR | UPPER | Text Functions