MID

Extracts a portion of a string, where the starting point and length are user-defined.

Parameter List

Syntax
MID(textstarting_atlength)
text

The string you want to extract the portion from.

starting_at

The character position you want the extraction to start from.

length

The number of characters of the extracted portion.

Examples

MID("123456789", 3, 5) returns 12345