Spread Formula Reference
Formula Functions / Functions R to S / RIGHT
In This Topic
    RIGHT
    In This Topic

    This function returns the specified rightmost characters from a text value.

    Syntax

    RIGHT(text,num_chars)

    Arguments

    This function has these arguments:

    Argument Description
    text Text string from which you want to return characters
    num_chars [Optional] Number of characters to return; if omitted, calculation uses one (1); if not an integer, the number is truncated

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

    The num_chars argument has these rules:

    Data Types

    Accepts string data for the text argument and numeric data for the num_chars argument. Returns string data.

    Examples

    RIGHT(""Total Sales"",5) gives the result Sales

    RIGHT(""Collie dog"") gives the result g

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    LEFT | MID | Text Functions