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

Published: 03 January 2022
on channel: Software Spring

6,409

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:

• Google Sheets Filter Function | Extract Da...
-------------------------------------

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.

On this page of the site you can watch the video online Google Sheets MID Function | Extract Substring from String | Spreadsheet Tutorial | Project with a duration of hours minute second in good quality, which was uploaded by the user Software Spring 03 January 2022, share the link with friends and acquaintances, this video has already been watched 6,409 times on youtube and it was liked by 42 viewers. Enjoy your viewing!

13,912

323