Excel MID() Function
The MID() function in excel is used to return a specific number of characters from a text string starting at the position you specify. One can change the start of the string, thus making MID function different from the LEFT function.
Syntax
MID(Text, [starting_position], [num_chars])
Parameter
Text (required)- This parameter represents the string from which you want to find letters.
starting_position(optional)- This parameter represents the starting position of the string.
num_chars(optional)- This parameter represents the number of characters you want to read from the starting of the string.
Category
Text
Return
This function returns the number of specified characters from the left to right wherein you can change or alter the start position of the string.
Example 1
Objective: Use MID function on the following strings
Text | Result | Formula |
Laptop restarted | top re | =MID(A22,4,6) |
EXCEL IS WOW | XCEL IS W | =MID(A23,2,9) |
SUPERSTORE IS CLOSED | E IS CLOS | =MID(A24,10,9) |
90 EMPLOYEES | 0 EMPL | =MID(A25,2,6) |
Example 2
Objective: Use MID function on the following strings
Name | Middle Name | Formula Used |
Sukla Rani Pati | ani P | =MID(B8,8,5) |
Rachel Buffay | Buffa | =MID(B9,8,5) |
Joey Mitchell | Tchel | =MID(B10,8,5) |
Chandler Kumar Patra | r Kum | =MID(B11,8,5) |
Delia Azahari | Zahar | =MID(B12,8,5) |
Mar Martin Castellano | tin C | =MID(B13,8,5) |
Daniel Oso | Oso | =MID(B14,8,5) |
Aman Singh Bhardwaj | ngh B | =MID(B15,8,5) |
Kriya Bhansali | Hansa | =MID(B16,8,5) |
Monica Bantónio | Bantó | =MID(B17,8,5) |