{"id":3312,"date":"2014-03-03T20:26:32","date_gmt":"2014-03-03T14:56:32","guid":{"rendered":"http:\/\/trumpexcel.com\/?page_id=3312"},"modified":"2023-09-29T15:23:01","modified_gmt":"2023-09-29T09:53:01","slug":"excel-mid-function","status":"publish","type":"post","link":"https:\/\/trumpexcel.com\/excel-mid-function\/","title":{"rendered":"How to Use Excel MID Function (Examples + Video)"},"content":{"rendered":"<h2><span style=\"color: #800000;\">Excel MID Function (Example + Video)<\/span><\/h2>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone wp-image-3269\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/MID-FORMULA-EXCEL.png\" alt=\"Excel MID Function\" width=\"450\" height=\"327\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/MID-FORMULA-EXCEL.png 752w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/MID-FORMULA-EXCEL-413x300.png 413w\" sizes=\"(max-width: 450px) 100vw, 450px\" \/><\/p>\n<h3><span style=\"color: #800000;\">When to use Excel MID Function<\/span><\/h3>\n<p>MID function can be used to extract a specified number of characters from a string.<\/p>\n<h3><span style=\"color: #800000;\">What it Returns<\/span><\/h3>\n<p>It returns the sub-string from a string.<\/p>\n<h3><span style=\"color: #800000;\">Syntax<\/span><\/h3>\n<p>=MID(text, start_num, num_chars)<\/p>\n<h3><span style=\"color: #800000;\">Input Arguments<\/span><\/h3>\n<ul>\n<li><strong>text<\/strong> &#8211; the text from which you want to extract the string.<\/li>\n<li><strong>start_num<\/strong> &#8211; the starting position within the text argument, from where the extraction should begin.<\/li>\n<li><strong>num_chars<\/strong> &#8211; the total number of characters\u00a0that you want to extract.<\/li>\n<\/ul>\n<h3><span style=\"color: #800000;\">Additional Notes<\/span><\/h3>\n<ul>\n<li>Spaces are <a href=\"https:\/\/trumpexcel.com\/count-characters-in-excel\/\">counted as characters<\/a>.\n<ul>\n<li>To remove extra\u00a0spaces, use TRIM function.<\/li>\n<\/ul>\n<\/li>\n<li>If the start number is greater than the length of the text, MID returns &#8220;&#8221; (empty text).<\/li>\n<li>Returns an error if:\n<ul>\n<li>The start number is less than 1.<\/li>\n<li>The number of characters is a negative number.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2><span style=\"text-decoration: underline;\"><span style=\"color: #800000; text-decoration: underline;\">Excel MID Function &#8211; Live Example<\/span><\/span><\/h2>\n<p><iframe src=\"https:\/\/onedrive.live.com\/embed?cid=7A7F3A8F4121E599&amp;resid=7A7F3A8F4121E599%21161&amp;authkey=AIyoFfj6O2jR0QE&amp;em=2&amp;AllowTyping=True&amp;wdDownloadButton=True\" width=\"580\" height=\"400\" frameborder=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<h2 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><span style=\"color: #800000; text-decoration: underline;\">Excel MID Function &#8211; Video Tutorial<\/span><\/span><\/h2>\n<p><iframe title=\"MID Formula in Excel\" width=\"1200\" height=\"675\" src=\"https:\/\/www.youtube.com\/embed\/vaitglEwheM?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/p>\n<p><strong><span style=\"color: #800000;\">Related Excel Functions:<\/span><\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-concatenate-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel CONCATENATE Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-left-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel LEFT Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-len-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel LEN Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-rept-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel REPT Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-right-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel RIGHT Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-text-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel TEXT Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-trim-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel TRIM Function<\/a>.<\/li>\n<\/ul>\n<p><strong>You may also like the following Excel tutorials:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/trumpexcel.com\/separate-first-and-last-name-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Split Names in Excel (Using Formulas)<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Excel MID Function (Example + Video) When to use Excel MID Function MID function can be used to extract a specified number of characters from a string. What it Returns It returns the sub-string from a string. Syntax =MID(text, start_num, num_chars) Input Arguments text &#8211; the text from which you want to extract the string. &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Use Excel MID Function (Examples + Video)\" class=\"read-more button\" href=\"https:\/\/trumpexcel.com\/excel-mid-function\/#more-3312\" aria-label=\"Read more about How to Use Excel MID Function (Examples + Video)\">Read more<\/a><\/p>\n","protected":false},"author":80,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[153],"tags":[19],"class_list":["post-3312","post","type-post","status-publish","format-standard","hentry","category-excel-functions","tag-excel-how-tos"],"_links":{"self":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/posts\/3312","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/users\/80"}],"replies":[{"embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/comments?post=3312"}],"version-history":[{"count":0,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/posts\/3312\/revisions"}],"wp:attachment":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/media?parent=3312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/categories?post=3312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/tags?post=3312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}