MID

Returns a segment of a string.

Usage examples 

MID("middle word middle", 8, 4)

Syntax 

MID ( value, starting, length )

• value - any string expression representing the string to extract a segment from.

• starting - any numeric expression representing the index (starting from 1) from the left of string from which to begin extracting.

• length - any numeric expression representing the length of the segment to extract.

Returns 

string - the segment of a string.

Functions reference