What if you need to extract something in between? You can do so using the MID<\/a> formula in Google Sheets.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text admin_label=”Connections T – One tool – Horizontal” module_class=”sheetgo-post-no-shadow-img md2-contained-button vertical-banner-container” _builder_version=”4.27.2″ _module_preset=”default” background_color=”#f2f7ff” max_width=”700px” module_alignment=”center” max_height=”300px” custom_margin=”20px|0px|20px|0px|true|true” custom_padding=”25px|25px|25px|25px|true|true” sticky_limit_bottom=”section” border_radii=”on|20px|20px|20px|20px” border_width_all=”1px” border_color_all=”#d9e7ff” global_colors_info=”{}” global_module=”50458″ theme_builder_area=”post_content”] One tool to merge, split, and filter all your spreadsheet data<\/span><\/p>\n Find out how<\/a>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.16″ border_width_left=”4px” global_colors_info=”{}” theme_builder_area=”post_content”]=MID(string, starting_at, extract_length)[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Nothing beats examples when it comes to understanding the concepts. So, I\u2019ll dive right in to reinforce what you\u2019ve learned from the syntax.<\/p>\n Take a look at the image below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/03\/1.-MID-example-1.png” alt=”MID Google Sheets example 1″ title_text=”1. MID example 1″ align=”center” _builder_version=”4.16″ _module_preset=”default” width=”640px” max_width=”640px” height=”440px” max_height=”440px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n To understand these examples easily, think of the output values as a segment cut out from an input string. In the first example, the formula picked the result \u201cdom\u201d from \u201cRandom text\u201d by going to the 4th character and extracting the text for a length of 3 characters. A similar process was repeated in the next two examples.<\/p>\n What if the formula reaches the end of the string before it extracts the extract_length<\/b> completely? The formula simply returns characters from starting_at<\/b> to the end of the string. So instead of generating an error, it just stops at the end of the string. I demonstrated this in the final example. The total length of the string \u201cConsistent\u201d is 10. I wanted the formula to start at the 7th position, and extract 6 characters after that. That implies that the formula should go until 12th character, which doesn\u2019t exist. So the formula just returned \u201ctent\u201d, because that is what is available until the end of the input string.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n It’s very useful to combine text functions together to dynamically extract information. While this is often done with the LEFT and RIGHT functions, you can also use MID to accomplish this.<\/p>\n In the example below, I have names embedded in sentences. I use the MID and LEN functions to extract the names only, with the formula =MID(A2,LEN(“My name is “),30)<\/b>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/03\/2.-MID-with-LEN.png” alt=”MID google sheets with LEN 2″ title_text=”2. MID with LEN” align=”center” _builder_version=”4.16″ _module_preset=”default” width=”640px” max_width=”640px” height=”440px” max_height=”440px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The LEN function determines the length of the first part of the phrase, then tells the MID function where to start extracting the substring. I set the extract_length<\/b> to 30 to be sure to get the full length of the name.<\/p>\n That\u2019s it! While MID is a fairly simple function, I hope you can now use it to make your own spreadsheets more efficient.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.22.2″ background_color=”#f9f9ff” custom_margin=”40px||40px||false|false” custom_padding=”15px|25px|15px|25px|true|true” border_width_left=”3px” border_color_left=”#808e95″ global_module=”26540″ saved_tabs=”all” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Editor\u2019s note<\/strong>: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness.<\/em><\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text admin_label=”Connections T – Automate beyond importrange – Horizontal” module_class=”sheetgo-post-no-shadow-img md2-contained-button-light vertical-banner-container” _builder_version=”4.27.2″ _module_preset=”default” background_color=”#f2f7ff” max_width=”700px” module_alignment=”center” max_height=”300px” custom_margin=”20px|0px|20px|0px|true|true” custom_padding=”25px|25px|25px|25px|true|true” sticky_limit_bottom=”section” border_radii=”on|20px|20px|20px|20px” border_width_all=”1px” border_color_all=”#d9e7ff” saved_tabs=”all” global_colors_info=”{}” global_module=”50462″ theme_builder_area=”post_content”] Automate data transfers beyond Importrange<\/span><\/p>\n Find out how<\/a>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" You can use spreadsheets not only for number crunching but for operating with text-based data as well. Google Sheets has a built-in support system to easily convert, trim and combine text strings. You may already be familiar with formulas like LEFT\u00a0and\u00a0RIGHT that help extract substrings from the left and right sides of a string respectively. […]<\/p>\n","protected":false},"author":40,"featured_media":33207,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"We use spreadsheets not only for number crunching but also for operating on the text-based data as well. There is a built-in support system to easily convert, trim and combine the strings. We know that we have formulas like LEFT<\/a> and RIGHT<\/a> that help us extract the substrings from the left and the right sides of a string respectively. What if we need to extract something in between? We can do so using the MID<\/a> formula in Google Sheets.\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/connections-top-processors-main.webp\")
<\/p>\n![\"39\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Recommended-for-Google-Workspace-badge.webp\"){kind=icon}
<\/p>\nSyntax<\/h3>\n
\n
Usage: MID function in Google Sheets<\/h3>\n
Combining MID with the LEN function<\/h4>\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Add-on-sm_sheets-connected-new-connection.webp\")
<\/p>\n<\/p>\nSyntax<\/h3>\nMID(string, starting_at, extract_length)<\/strong>\n
\n \t
Usage: MID formula in Google Sheets<\/h3>\nNothing beats examples when it comes to understanding the concepts. So, let us dive right into them and reinforce what we've learned from the syntax. Have a look at the image below.\n\n
![\"MID](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/07\/MID-formula-Illustration-Frame-2.png\")
\n\nTo understand these examples easily, think of the output values as a segment cut out from an input string. In the first example, the formula picked result \"dom\" from the 4th position of \"Random text\", until it is 3 characters long. Similar is the case with the next two examples.\n\nWhat if the formula reaches the end of the string even before it traverses the extract_length<\/strong> completely? The formula simply returns characters from starting_at<\/strong> to the end of the string. We demonstrated this in the final example. The total length of the string \"Consistent\" is 10. We wanted the formula to start at the 7th position, and extract 6 characters after that. That implies that the formula should traverse until 12th character, which doesn't exist. So the formula just returned \"tent\", because that is what is available until the end of the input string.","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-9183","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/9183","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=9183"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/9183\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/33207"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=9183"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=9183"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=9183"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}