MID

Extracts the characters from a text string beginning at the offset value. The first character in a string has an offset of 1, the second 2, and so forth. .

Syntax

MID(text-expression,start-offset,num_chars)

Arguments

text-expression Text or cell reference to extract a string from.

start-offset The offset location in the text expression. Must be greater than or equal to 1.

number Total number of charcters to extract.

Example

MID("Gobe Software",2,5) returns "be So"

text-expression	Text or cell reference to extract a string from.
start-offset	The offset location in the text expression. Must be greater than or equal to 1.
number	Total number of charcters to extract.