MID

Return a specified number of characters from the middle of a text string, starting at a specific position.

The MID function returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify. When used with a number, the resultant value is stored as text.

Syntax

mid (text, position, length)

Arguments

text/number - The text string containing the characters you want to extract. Required.

position - The position of the first character you want to extract in the text. Required.

length - Specifies the number of characters you want MID to return from the text. Required.

Example

mid([Full Name],0,7)
//When the field Full Name has the value Johny Rivers, this will return Johny R

Mid function

Excel equivalent

MID