MID Function splits the data from the middle of the character. If you want to remove any character from left or right from a cell in Excel, then you should use LEFT Function, right function.
Syntax
=MID (text, start_num, num_chars)
Text: the text string from which you want to extract characters
start_num: the position at which you want to start extracting characters
num_chars: the number of characters you want to extract
As you can see in the image below that we have a data in which city names are given in Column A and their pin code numbers are also given.
Now we have to separate the pin code from that data. And here we will use MID Function.
Example : =MID(A2,9,7)
Here A2 is the address of a cell in which text data is stored and we have to split from it, 9 is the starting position from where to start text splitting, and 7 is in the last It means that this mid function will display up to 7 characters from the selected cell, in the same way the rest will also be removed.
