Syntax

MID(some-text, begin-at, how-many)

Arguments

  • some-text (any textual)
  • begin-at (Number) : The position, equal to or greater than 1, of the first character in some-text to return. A non-Number value may be accepted but may produce unexpected results.
  • how-many (Number) : The non-negative number of characters from some-text to return. A non-Number value may be accepted but may produce unexpected results.

Return Value

Text: The how-many characters beginning at position begin-at from some-text. If how-many is greater than the remaining length of some-text, the remainder of some-text is returned.

Examples

MID("123 Maple Dr", 5, 5) : Maple

MID("123 Maple Dr", 5, 0) returns blank.

See Also

INITIALS(), LEFT(), RIGHT()

Did this answer your question?