MID

Returns a specified sub-string from a text string.

Syntax:

MID(text, start:Number, length:Number)

Returns the middle length characters from the text string starting at position start.

Example:

MID("middle of the road", 8, 6)

returns the text string "of the".