<< Click to Display Table of Contents >> MID (part of a text string)

Syntax:

MID(TextString, Start, Count)

Description:

This returns a part of a TextString.

The section starts at Start and is Count characters long.

Example:

MID("peanut", 2, 3) returns ean

MID("peanut", 2, 5) returns eanut

MID("peanut", 2, 100) also returns eanut

MID("peanut", 100, 100) returns an empty text string

See also:

LEFT, RIGHT, REPLACE, FIND, SEARCH, LEN