Google Sheets MID Function | Extract Substring from String | Spreadsheet Tutorial | Project

Use the Google Sheets MID function to extract a substring from a specified string. The other attributes you should specify are starting position and the length of the substring to extract.

Combine the MID function with other functions like SEARCH, LEN, or
FIND to make MID more powerful.

-------------------------------------
The FILTER function

The FILTER function filters data based on one or more conditions. Review
this step-by-step tutorial on FILTER to know more:

-------------------------------------

Here is the format of the MID function formula:

=MID(string, starting_at, extract_length)

Start the formula with an equal-to symbol.

MID is the name of the function.

string is the text from which you want to extract a substring.

starting_at is the starting position from which to begin extracting the substring.

extract_length is the number of characters to extract from the starting position.

Let's look at a few examples of the MID function formula:

Example 1

=MID("Sales Data", 7, 4)

The above function formula begins to extract the substring, starting at the seventh character and ending after the fourth character.

The output will be Data.

Example 2

=MID("Sales Data", 7, 3)

The formula returns Dat, because the extract_length attribute value is 3.

Example 3

=MID("Sales Data", 7, 9)

Here the extract_length value is more than the number of characters in the
substring from the starting position. What does the function return in
such a case? It returns all the characters from the starting position.

The output will be Data, which is the same as that of the formula in
Example 1.

Take a look at this video tutorial, which gives the steps to use the Google Sheets MID function with examples. The tutorial also has a project, which pertains to nesting the SEARCH function inside MID to extract specific data from a string.