Author: Oscar Cronquist Article last updated on April 19, 2018

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)


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.


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.