Category: Text function

This function returns a substring of text from text, length characters long, and starting with the character in position start.

Return value type: Text

Number values entered for text are implicitly converted to text.

Entering a value for start that is past the number of characters in text returns and empty value.

Entering a value for length that exceeds the number of characters after the start position, returns the text up to the end of text.

mid('27.03.2015', 4, 2) //Returns '03'

mid('Los Angeles', 5, 5) //Returns 'Angel'

mid('Mary', 3, 5) //Returns 'ry'  (Returns characters to the end of the text.)

mid(123456, 4, 3) //Returns '456' (Number implicitly converted; return value is a string.)

mid('Mary', 5, 3) //Returns an empty value (The starting point is past the end of the text.)

• Left(text, no_of_chars)
• Remove(text, start, length)
• Right(text, no_of_chars)