MID

Returns a text segment of a character string. The parameters specify the starting position and the number of characters.

MID(text; start; number)

text is the text containing the characters to extract.

start is the position of the first character in the text to extract.

number specifies the number of characters in the part of the text.

MID("Sun Microsystems";5;5) returns Micro.