Navigation:  Formulas and functions > Functions from A to Z > MID (part of a text string)

Syntax:

MID(Text, Start, Count)

Description:

This returns a part of a Text string.

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