MID function

Category: Text functions

What does this function do?

Returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.

Syntax:

MID(text, start_num, num_chars)

• text (required): text string that contains the characters you want to extract
• start_num (required): the position of the first character you want to extract in text. The first character in text has start_num 1, and so on.
• num_chars (required): specifies the number of characters you want to extract.

Examples:

=MID("Excel",2,2)= "xc"