MID

The MID function returns a specific number of characters from a text string, starting at the position you specify.

Syntax

=MID(text, start_num, num_chars)

Parameters

• text: The text string from which you want to extract characters
• start_num: The position of the first character you want to extract
• num_chars: The number of characters to extract

Examples

=MID("Hello World", 7, 5) // Returns "World"
=MID("Excel Formula", 1, 5) // Returns "Excel"
=MID("123456", 2, 3) // Returns "234"