MID (part of a text string)

<< Click to Display Table of Contents >>

MID (part of a text string)

Syntax:

MID(Text, Start, Count)

Description:

Returns a section of a Text string.

The section starts at character Start and is Count characters long.

Example:

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

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

MID("peanut", 2, 100) returns eanut as well

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

See also:

LEFT, RIGHT, REPLACE, FIND, SEARCH, LEN