{"id":1003,"date":"2021-11-17T12:37:26","date_gmt":"2021-11-17T12:37:26","guid":{"rendered":"https:\/\/vueittraining.co.uk\/?p=1003"},"modified":"2021-11-17T12:37:26","modified_gmt":"2021-11-17T12:37:26","slug":"autofill-in-excel-2013-2016","status":"publish","type":"post","link":"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/","title":{"rendered":"Autofill in Excel 2013\/2016"},"content":{"rendered":"\n<p>Now I have been a bit late getting to the party on this one! But having used it a couple of times, I have begun to see its potential.<\/p>\n\n\n\n<p>Imagine you have two text strings in Columns A and B, and want to join them together in Column C. In older versions of Excel, you need to use the CONCATENATE functions.<\/p>\n\n\n\n<p>In Excel 2013\/2016, type the completed text string in the cell (eg C1). Position your mouse in the bottom left corner of the cell to be copied, then click and drag down with your RIGHT MOUSE button. From the menu choose Flash Fill.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/www.vueittraining.co.uk\/wp-content\/uploads\/2017\/03\/autofill-excel-1.png\"><img decoding=\"async\" src=\"https:\/\/www.vueittraining.co.uk\/wp-content\/uploads\/2017\/03\/autofill-excel-1.png\" alt=\"\" class=\"wp-image-361\"\/><\/a><\/figure><\/div>\n\n\n\n<p>This works for a variety of text strings, as long as Excel can identify the pattern. In the example below, we are trying to extract the first names from the email addresses. By typing the first name in B1, and using flash fill, Excel recognises the pattern, and repeats the same action for each email address.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/www.vueittraining.co.uk\/wp-content\/uploads\/2017\/03\/autofill-excel-2.png\"><img decoding=\"async\" src=\"https:\/\/www.vueittraining.co.uk\/wp-content\/uploads\/2017\/03\/autofill-excel-2.png\" alt=\"\" class=\"wp-image-362\"\/><\/a><\/figure><\/div>\n\n\n\n<p>Want to find out more? Contact me about an Excel course<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Now I have been a bit late getting to the party on this one! But having used it a couple of times, I have begun to see its potential. Imagine you have two text strings in Columns A and B, and want to join them together in Column C. In older versions of Excel, you&#8230;<\/p>\n","protected":false},"author":1,"featured_media":1004,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[1],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Autofill in Excel 2013\/2016 - VUE IT TRAINING<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Autofill in Excel 2013\/2016 - VUE IT TRAINING\" \/>\n<meta property=\"og:description\" content=\"Now I have been a bit late getting to the party on this one! But having used it a couple of times, I have begun to see its potential. Imagine you have two text strings in Columns A and B, and want to join them together in Column C. In older versions of Excel, you...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/\" \/>\n<meta property=\"og:site_name\" content=\"VUE IT TRAINING\" \/>\n<meta property=\"article:published_time\" content=\"2021-11-17T12:37:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vueittraining.co.uk\/wp-content\/uploads\/2021\/11\/autofill-excel-1-300x286-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"286\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"tony\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"tony\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/\"},\"author\":{\"name\":\"tony\",\"@id\":\"https:\/\/vueittraining.co.uk\/#\/schema\/person\/96e030c56bce24df2d9166db0ba7ef5c\"},\"headline\":\"Autofill in Excel 2013\/2016\",\"datePublished\":\"2021-11-17T12:37:26+00:00\",\"dateModified\":\"2021-11-17T12:37:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/\"},\"wordCount\":173,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/vueittraining.co.uk\/#organization\"},\"image\":{\"@id\":\"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vueittraining.co.uk\/wp-content\/uploads\/2021\/11\/autofill-excel-1-300x286-1.png\",\"articleSection\":[\"Blogs\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/\",\"url\":\"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/\",\"name\":\"Autofill in Excel 2013\/2016 - VUE IT TRAINING\",\"isPartOf\":{\"@id\":\"https:\/\/vueittraining.co.uk\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vueittraining.co.uk\/wp-content\/uploads\/2021\/11\/autofill-excel-1-300x286-1.png\",\"datePublished\":\"2021-11-17T12:37:26+00:00\",\"dateModified\":\"2021-11-17T12:37:26+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/#primaryimage\",\"url\":\"https:\/\/vueittraining.co.uk\/wp-content\/uploads\/2021\/11\/autofill-excel-1-300x286-1.png\",\"contentUrl\":\"https:\/\/vueittraining.co.uk\/wp-content\/uploads\/2021\/11\/autofill-excel-1-300x286-1.png\",\"width\":300,\"height\":286},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vueittraining.co.uk\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Autofill in Excel 2013\/2016\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vueittraining.co.uk\/#website\",\"url\":\"https:\/\/vueittraining.co.uk\/\",\"name\":\"VUE IT TRAINING\",\"description\":\"Microsoft 365 Training\",\"publisher\":{\"@id\":\"https:\/\/vueittraining.co.uk\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vueittraining.co.uk\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/vueittraining.co.uk\/#organization\",\"name\":\"VUE IT TRAINING\",\"url\":\"https:\/\/vueittraining.co.uk\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vueittraining.co.uk\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/vueittraining.co.uk\/wp-content\/uploads\/2021\/06\/cropped-newvuelogo.png\",\"contentUrl\":\"https:\/\/vueittraining.co.uk\/wp-content\/uploads\/2021\/06\/cropped-newvuelogo.png\",\"width\":886,\"height\":378,\"caption\":\"VUE IT TRAINING\"},\"image\":{\"@id\":\"https:\/\/vueittraining.co.uk\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/vueittraining.co.uk\/#\/schema\/person\/96e030c56bce24df2d9166db0ba7ef5c\",\"name\":\"tony\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vueittraining.co.uk\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/252cb3b33c013882a0f83de20c9e6a47?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/252cb3b33c013882a0f83de20c9e6a47?s=96&d=mm&r=g\",\"caption\":\"tony\"},\"sameAs\":[\"https:\/\/vueittraining.co.uk\"],\"url\":\"https:\/\/vueittraining.co.uk\/author\/tony\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Autofill in Excel 2013\/2016 - VUE IT TRAINING","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/","og_locale":"en_US","og_type":"article","og_title":"Autofill in Excel 2013\/2016 - VUE IT TRAINING","og_description":"Now I have been a bit late getting to the party on this one! But having used it a couple of times, I have begun to see its potential. Imagine you have two text strings in Columns A and B, and want to join them together in Column C. In older versions of Excel, you...","og_url":"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/","og_site_name":"VUE IT TRAINING","article_published_time":"2021-11-17T12:37:26+00:00","og_image":[{"width":300,"height":286,"url":"https:\/\/vueittraining.co.uk\/wp-content\/uploads\/2021\/11\/autofill-excel-1-300x286-1.png","type":"image\/png"}],"author":"tony","twitter_card":"summary_large_image","twitter_misc":{"Written by":"tony","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/#article","isPartOf":{"@id":"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/"},"author":{"name":"tony","@id":"https:\/\/vueittraining.co.uk\/#\/schema\/person\/96e030c56bce24df2d9166db0ba7ef5c"},"headline":"Autofill in Excel 2013\/2016","datePublished":"2021-11-17T12:37:26+00:00","dateModified":"2021-11-17T12:37:26+00:00","mainEntityOfPage":{"@id":"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/"},"wordCount":173,"commentCount":0,"publisher":{"@id":"https:\/\/vueittraining.co.uk\/#organization"},"image":{"@id":"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/#primaryimage"},"thumbnailUrl":"https:\/\/vueittraining.co.uk\/wp-content\/uploads\/2021\/11\/autofill-excel-1-300x286-1.png","articleSection":["Blogs"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/","url":"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/","name":"Autofill in Excel 2013\/2016 - VUE IT TRAINING","isPartOf":{"@id":"https:\/\/vueittraining.co.uk\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/#primaryimage"},"image":{"@id":"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/#primaryimage"},"thumbnailUrl":"https:\/\/vueittraining.co.uk\/wp-content\/uploads\/2021\/11\/autofill-excel-1-300x286-1.png","datePublished":"2021-11-17T12:37:26+00:00","dateModified":"2021-11-17T12:37:26+00:00","breadcrumb":{"@id":"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/#primaryimage","url":"https:\/\/vueittraining.co.uk\/wp-content\/uploads\/2021\/11\/autofill-excel-1-300x286-1.png","contentUrl":"https:\/\/vueittraining.co.uk\/wp-content\/uploads\/2021\/11\/autofill-excel-1-300x286-1.png","width":300,"height":286},{"@type":"BreadcrumbList","@id":"https:\/\/vueittraining.co.uk\/autofill-in-excel-2013-2016\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vueittraining.co.uk\/"},{"@type":"ListItem","position":2,"name":"Autofill in Excel 2013\/2016"}]},{"@type":"WebSite","@id":"https:\/\/vueittraining.co.uk\/#website","url":"https:\/\/vueittraining.co.uk\/","name":"VUE IT TRAINING","description":"Microsoft 365 Training","publisher":{"@id":"https:\/\/vueittraining.co.uk\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vueittraining.co.uk\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/vueittraining.co.uk\/#organization","name":"VUE IT TRAINING","url":"https:\/\/vueittraining.co.uk\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vueittraining.co.uk\/#\/schema\/logo\/image\/","url":"https:\/\/vueittraining.co.uk\/wp-content\/uploads\/2021\/06\/cropped-newvuelogo.png","contentUrl":"https:\/\/vueittraining.co.uk\/wp-content\/uploads\/2021\/06\/cropped-newvuelogo.png","width":886,"height":378,"caption":"VUE IT TRAINING"},"image":{"@id":"https:\/\/vueittraining.co.uk\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/vueittraining.co.uk\/#\/schema\/person\/96e030c56bce24df2d9166db0ba7ef5c","name":"tony","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vueittraining.co.uk\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/252cb3b33c013882a0f83de20c9e6a47?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/252cb3b33c013882a0f83de20c9e6a47?s=96&d=mm&r=g","caption":"tony"},"sameAs":["https:\/\/vueittraining.co.uk"],"url":"https:\/\/vueittraining.co.uk\/author\/tony\/"}]}},"_links":{"self":[{"href":"https:\/\/vueittraining.co.uk\/wp-json\/wp\/v2\/posts\/1003"}],"collection":[{"href":"https:\/\/vueittraining.co.uk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vueittraining.co.uk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vueittraining.co.uk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vueittraining.co.uk\/wp-json\/wp\/v2\/comments?post=1003"}],"version-history":[{"count":1,"href":"https:\/\/vueittraining.co.uk\/wp-json\/wp\/v2\/posts\/1003\/revisions"}],"predecessor-version":[{"id":1005,"href":"https:\/\/vueittraining.co.uk\/wp-json\/wp\/v2\/posts\/1003\/revisions\/1005"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vueittraining.co.uk\/wp-json\/wp\/v2\/media\/1004"}],"wp:attachment":[{"href":"https:\/\/vueittraining.co.uk\/wp-json\/wp\/v2\/media?parent=1003"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vueittraining.co.uk\/wp-json\/wp\/v2\/categories?post=1003"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vueittraining.co.uk\/wp-json\/wp\/v2\/tags?post=1003"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}