Extract Part of Strings 2

The MID function in excel is another function to extract part of the string. Please download related file from this link. 

This function requires 3 inputs.

1. text
2. start_num
3. num_charts

The syntax for this function is MID(text, start_num, num_chars). "text" denotes the string. We can enter this as a string ("Apple") or link (A1) to a cell. "start_number" represents the place of the first character of output string & "num_chars" represents the count of characters in the output string.

As an example, if we need to extract "App" from string "Apple". The first character of the output string is "A" and it is the first character. Then syntax for the function is

=MID("Apple,1,3).

If "Apple" is entered into the cell A1 then

=MID(A1,1,3)