Excel MID Function |
Explanation
The MID function extracts a portion of text, starting in the middle of text.
Syntax
The syntax for MID function is as follows:
= MID( text , starting number , number of characters to extract)
Simple Uses of MID Function
1. To extract the first five characters from name.
1. To extract the first five characters from name.
Follow the steps shown in the image below.
Practical Uses of MID Function
1. Extract First Name
2. To extract five characters from name, starting from the third character.
Follow the steps shown in the image below.
Practical Uses of MID Function
1. Extract First Name
Suppose a person's full name is entered in cell A2. Enter the following formula in cell B2
Logic : We need to extract characters till last character before space.
=MID (A2,1,FIND(" ",A2)-1)
1 => Start from first character
The FIND Function finds the position of a portion of text in a text.
In this case, it finds the position of a space in the name.
2. Extract Last Name
Suppose a person's full name is entered in cell A2. Enter the following formula in cell B2
Logic : We need to extract characters starting from first character after space.
=MID (A2,FIND(" ",A2)+1,25)
The FIND Function finds the position of a space in the name.
25 : I assumed maximum number of characters in a last name would be 25.
3. Convert a Text Value into Date
=DATE(LEFT(A2,4),MID(A2,5,2),RIGHT(A2,2))
The DATE Function returns the sequential serial number that represents a particular date.
DATE(year,month,day)
MID(A2,5,2) => 12
RIGHT(A2,2) => 09
clear information regarding mid function
ReplyDelete