Mid
The Mid function returns a specific number characters from text string, starting at the position you specify.
Usage:
= Mid(<text>, <start_num>, <num_chars>);
<Text> is the text string containing the characters you want to extract.
<Start_num> is the position of the first character you want to extract in <text>. <Start_num> must be greater than zero.
<Num_chars> specifies how many characters you want the function to return. <Num_chars> must be positive.
Examples:
/* Returns 'Wor'
= Mid("Hello World", 7, 3);
/* Returns 'World'
= Mid("Hello World", 7, 100);