# How to use Excel MID function

## Quick view of Excel MID Function

Explanation: In the above table, MID function is applied to the data and the results are from D49 to D54. The formula can be seen in E column.

#### Excel MID Function

The Excel MID function helps us to extract the desired number of characters from the middle part of the selected cell.

#### Purpose (When to use MID Function)

The MID function is used to extract the Text from MID of a string.

#### Return value (Result)

MID function helps us in fetching the desired text & desired number of characters.

#### Syntax (Rules to use MID Function)

=MID (text, start_num, num_chars)

#### Arguments (Parts of Syntax)

1. text – The text from which you wish to extract Characters.
2. Start_num – The location of the first character of the text you would like to extract from the selected cell. Note: – Spaces needs to be considered.
3. Num_chars – The number of characters of the text you would like to extract.
##### Explanations:-

To extract the Middle characters of John Wilson Smith

=MID(“John Wilson Smith”,6,6) gives us “Wilson”.

To extract the Middle characters of David Donald Wilson

=MID(“David Donald Wilson”,7,6) fetches “Donald”.

To extract the Middle characters of 180-0789-3210

=MID(“180-0789-3210”,5,4) fetches “0789”.

To extract the Middle characters of (330)-863-5328

=MID(“(330)-863-5328”,7,3) fetches 863 as a text.