The MID function returns a substring from a string based on theĀ starting position and the number of characters you want to extract.

Excel Function Syntax

MID(text, start_num, num_chars)

Arguments

text Text string or a cell reference to a text string.
start_num The starting point.
num_chars The number of characters you want to extract.

Example

The first argument is the text string, the second argument is the start position. In this case character number 3, note spaces are counted.

The third argument is how many characters you want to extract counted from the start position.