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

    This function returns the requested number of characters from a text string starting at the position you specify.

    Syntax

    MID(text,start_num,num_chars)

    Arguments

    This function has these arguments:

    Argument Description
    text Text string containing the characters you want to extract
    start_num Number representing the first character you want to extract in text, with the first character in the text having a value of one (1); if not an integer, the number is truncated
    num_chars Number of characters to return from text; 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 start_num argument has these rules

    Data Types

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

    Examples

    MID(B17,5,8)

    MID(""wind surfing"", 6, 20) gives the result surfing

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    LEFT | RIGHT | Text Functions