How to use Excel MID function

Download the Excel File with examples

Quick view of Excel MID Function

How to use 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.
Excel MID function
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.

Download the Excel File with examples