The MID function

The MID function returns the text from any middle part of our text string based on the starting position and number of characters specified.

Syntax:

MID(text, start_num, num_chars)

Parameters:

• Text: The text we want to extract from.  
• start_num: The starting number of the first character from the text we want to extract.
• Num_chars: The number of characters you want to extract.

Example:

Step 1: Format your data.

Now if you want to get the character “for” which is located in the middle of our text “w3wiki” in B2. Let us follow the next step.

Step 2: We will enter =MID(B2,5,3) in the B3 cell. Here we want Excel to extract the characters located in the middle of our text in B2.

This will return “for”.

Excel is mostly about numerical, however, we often have data of text data type. Here are a few functions we should know to handle text data.

• LEFT
• RIGHT
• MID
• LEN
• FIND