How to use the MID function in Excel
How to use the MID function in Excel
Learn how to use the MID function in Microsoft Excel. This tutorial demonstrates how to use Excel MID with our easy to follow examples and takes you step-by-step through the different options when entering your formula.
MID Function (and sample data):
https://www.techonthenet.com/excel/fo…
Excel Functions/Formulas:
https://www.techonthenet.com/excel/fo…
Excel Tutorials:
https://www.techonthenet.com/excel/in…
Don’t forget to subscribe to our channel for more great Excel tutorials!
Visit us at: https://www.techonthenet.com
or follow us on:
Facebook: https://www.facebook.com/techonthenetcom
Twitter: https://twitter.com/tech_on_the_net
Pinterest: https://www.pinterest.com/techonthene…
Content
0.02 -> The MID function is a useful
string function in Excel
4.02 -> The MID function is used to
extract a substring from a string
8.182 -> As you write more formulas in Excel,
you will find so many uses for the MID function
13.6 -> To see how the MID function works,
let's look at a few examples
17.68 -> In column A, we've listed our
string/text values that we want to extract from
23.16 -> In column B, we have the position in the string
where we will start the extraction
28.38 -> and in column C, we have the number
of characters that we wish to extract
33.2 -> To get started, let's begin by entering
the MID command
37.02 -> As you can see, the MID function
takes three parameters
40.68 -> The first parameter we will need to enter is
the string that we wish to extract from
45.86 -> This parameter can either be a value
or the reference to a cell that contains a value
51.56 -> In our example, we will enter cell A2
which contains the value "TechOnTheNet"
57.34 -> The second parameter is the position
in the string to begin the extraction
62.301 -> The first position in the string is 1,
the second position is 2, and so on
67.9 -> Again, this parameter can either be
a value or the reference to a cell
72.78 -> In our example, we will enter cell B2
which contains the value 1
78.06 -> This means that we will begin the extraction
at the first position in the string "TechOnTheNet"
83.7 -> The third position is the number
of characters to extract
87.58 -> We will enter the cell C2
which contains the value 1
92.26 -> This means that we will only want to extract
one character from the string "TechOnTheNet"
97.76 -> Now, let's see what our
MID function returns
101.2 -> You should see the string value "T"
appear in cell E2
105.5 -> In this example, the MID function extracted the first
character from the string "TechOnTheNet"
112.02 -> Now let's copy our formula down to
cell E3 to E5
116.68 -> In cell E3, the MID function started at the first position
120.82 -> and extracted four characters from the string
"TechOnTheNet" returning the value "Tech"
127.08 -> In cell E4, the MID function
started at the fifth position
131.4 -> and extracted five characters
returning the value "OnThe"
135.8 -> And finally, in cell E5, the MID function
started at the tenth position
141.18 -> and extracted three characters
returning the value "Net"
145 -> This covers a few basic examples of
how to use the Excel MID function
150.04 -> If you would like to see more examples
152.4 -> or would like to download
the sample data we used for this tutorial
155.9 -> please visit our website
at TechOnTheNet.com
159.22 -> If you found our tutorial helpful,
please leave a like on this video
162.96 -> and don't forget to subscribe to our YouTube channel
for more great Excel tutorials
Source: https://www.youtube.com/watch?v=eUbJGOD0dNA