MID

Returns a specific number of characters from a text string, starting at the position you specify.

Syntax

MID(text, start_num, num_chars)

Arguments

• text: The text string from which to extract characters.
• start_num: The position of the first character to extract (starting from 1).
• num_chars: The number of characters to extract.

Example

MID("AnyDB Data Store", 7, 4) → Returns "Data"
MID(A1, 2, 3) → Returns 3 characters from cell A1, starting from the second character