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

    This function returns the requested number of characters from a text string starting at the position you have specified (on the basis of the specified number of bytes).

    Syntax

    MIDB(text,start_num,num_bytes)

    Arguments

    This function has the following arguments:

    Argument Description
    text Refers to the text string containing the characters you want to extract.
    start_num Refers to the 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 this value is not an integer, the number is truncated.
    num_bytes Refers to the number of characters to return from text (in bytes). If this value is not an integer, the number is truncated.

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

    The start_num argument works on the following rule:

    Remarks

    The MIDB function counts 2 bytes per character, but this happens only when a DBCS language is set as the default language.

    Data Types

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

    Examples

    MIDB("rosy garden", 6, 20) gives the result garden.

    Version Available

    This function is available in Spread for Windows Forms 11.0 or later.