Spread Formula Reference
Formula Functions / Functions T to Z / TRIM
In This Topic
    TRIM
    In This Topic

    This function removes extra spaces from a string and leaves single spaces between words.

    Syntax

    TRIM(text)

    Arguments

    The argument specifies the string containing the spaces you want to remove.

    Data Types

    Accepts string data. Returns string data.

    Examples

    TRIM("" First    Quarter"") gives the result First Quarter

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    CLEAN | SUBSTITUTE | Text Functions