{"id":551,"date":"2009-08-18T14:56:00","date_gmt":"2009-08-18T14:56:00","guid":{"rendered":"https:\/\/brainlitter.itgroove.net\/2009\/08\/18\/how-to-use-excel-2007-to-separate-a-column-that-has-first-name-and-last-name-separated-by-a-space-into-two-separate-columns\/"},"modified":"2009-08-18T14:56:00","modified_gmt":"2009-08-18T14:56:00","slug":"how-to-use-excel-2007-to-separate-a-column-that-has-first-name-and-last-name-separated-by-a-space-into-two-separate-columns","status":"publish","type":"post","link":"https:\/\/regroove.ca\/brainlitter\/2009\/08\/18\/how-to-use-excel-2007-to-separate-a-column-that-has-first-name-and-last-name-separated-by-a-space-into-two-separate-columns\/","title":{"rendered":"How to use Excel 2007 to separate a Column that has First Name and Last Name, separated by a space, into two separate columns"},"content":{"rendered":"<div class=\"ExternalClass0968BF1A80A347C99E32C8D0B05FD730\">\n<p>This seemed a worthy 30 second video\/overview to share as I run into this enough that others must too. I needed to take an existing spreadsheet, that had several sheets of &#8216;users&#8217; where the Username and Password were in the same column\/field. I needed to separate them into separate columns, with minimal effort (read: lazy) \u2013 I had many more to do, than the 5 in this sampler \u2013 but you can see how easy\/quick this process actually was. <\/p>\n<p>\u00a0<\/p>\n<p>Video link: <a>http:\/\/screencast.com\/t\/2s0gSd39lqtt<\/a> <\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p><a href=\"http:\/\/screencast.com\/t\/2s0gSd39lqtt\"><img decoding=\"async\" border=\"0\" alt=\"\" src=\"\/brainlitterarchive\/Lists\/Photos\/081809_2156_HowtouseExc1.png\"><\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>This seemed a worthy 30 second video\/overview to share as I run into this enough that others must too. I needed to take an existing spreadsheet, that had several sheets of &#8216;users&#8217; where the Username and Password were in the same column\/field. I needed to separate them into separate columns, with minimal effort (read: lazy) &hellip; <a href=\"https:\/\/regroove.ca\/brainlitter\/2009\/08\/18\/how-to-use-excel-2007-to-separate-a-column-that-has-first-name-and-last-name-separated-by-a-space-into-two-separate-columns\/\"><\/a><\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":"","_jetpack_memberships_contains_paid_content":false},"categories":[429],"tags":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to use Excel 2007 to separate a Column that has First Name and Last Name, separated by a space, into two separate columns - Brainlitter - Inside the mind of Sean Wallbridge<\/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:\/\/regroove.ca\/brainlitter\/2009\/08\/18\/how-to-use-excel-2007-to-separate-a-column-that-has-first-name-and-last-name-separated-by-a-space-into-two-separate-columns\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to use Excel 2007 to separate a Column that has First Name and Last Name, separated by a space, into two separate columns - Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"og:description\" content=\"This seemed a worthy 30 second video\/overview to share as I run into this enough that others must too. I needed to take an existing spreadsheet, that had several sheets of &#8216;users&#8217; where the Username and Password were in the same column\/field. I needed to separate them into separate columns, with minimal effort (read: lazy) &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/regroove.ca\/brainlitter\/2009\/08\/18\/how-to-use-excel-2007-to-separate-a-column-that-has-first-name-and-last-name-separated-by-a-space-into-two-separate-columns\/\" \/>\n<meta property=\"og:site_name\" content=\"Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"article:published_time\" content=\"2009-08-18T14:56:00+00:00\" \/>\n<meta name=\"author\" content=\"Sean Wallbridge\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sean Wallbridge\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2009\/08\/18\/how-to-use-excel-2007-to-separate-a-column-that-has-first-name-and-last-name-separated-by-a-space-into-two-separate-columns\/\",\"url\":\"https:\/\/regroove.ca\/brainlitter\/2009\/08\/18\/how-to-use-excel-2007-to-separate-a-column-that-has-first-name-and-last-name-separated-by-a-space-into-two-separate-columns\/\",\"name\":\"How to use Excel 2007 to separate a Column that has First Name and Last Name, separated by a space, into two separate columns - Brainlitter - Inside the mind of Sean Wallbridge\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\"},\"datePublished\":\"2009-08-18T14:56:00+00:00\",\"dateModified\":\"2009-08-18T14:56:00+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\"},\"breadcrumb\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2009\/08\/18\/how-to-use-excel-2007-to-separate-a-column-that-has-first-name-and-last-name-separated-by-a-space-into-two-separate-columns\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/regroove.ca\/brainlitter\/2009\/08\/18\/how-to-use-excel-2007-to-separate-a-column-that-has-first-name-and-last-name-separated-by-a-space-into-two-separate-columns\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2009\/08\/18\/how-to-use-excel-2007-to-separate-a-column-that-has-first-name-and-last-name-separated-by-a-space-into-two-separate-columns\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Brainlitter\",\"item\":\"https:\/\/regroove.ca\/brainlitter\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to use Excel 2007 to separate a Column that has First Name and Last Name, separated by a space, into two separate columns\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\",\"url\":\"https:\/\/regroove.ca\/brainlitter\/\",\"name\":\"Brainlitter - Inside the mind of Sean Wallbridge\",\"description\":\"Dad. Husband. Drummer. Learner of Things.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/regroove.ca\/brainlitter\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\",\"name\":\"Sean Wallbridge\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g\",\"caption\":\"Sean Wallbridge\"},\"url\":\"https:\/\/regroove.ca\/brainlitter\/author\/swallbridge\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to use Excel 2007 to separate a Column that has First Name and Last Name, separated by a space, into two separate columns - Brainlitter - Inside the mind of Sean Wallbridge","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:\/\/regroove.ca\/brainlitter\/2009\/08\/18\/how-to-use-excel-2007-to-separate-a-column-that-has-first-name-and-last-name-separated-by-a-space-into-two-separate-columns\/","og_locale":"en_US","og_type":"article","og_title":"How to use Excel 2007 to separate a Column that has First Name and Last Name, separated by a space, into two separate columns - Brainlitter - Inside the mind of Sean Wallbridge","og_description":"This seemed a worthy 30 second video\/overview to share as I run into this enough that others must too. I needed to take an existing spreadsheet, that had several sheets of &#8216;users&#8217; where the Username and Password were in the same column\/field. I needed to separate them into separate columns, with minimal effort (read: lazy) &hellip;","og_url":"https:\/\/regroove.ca\/brainlitter\/2009\/08\/18\/how-to-use-excel-2007-to-separate-a-column-that-has-first-name-and-last-name-separated-by-a-space-into-two-separate-columns\/","og_site_name":"Brainlitter - Inside the mind of Sean Wallbridge","article_published_time":"2009-08-18T14:56:00+00:00","author":"Sean Wallbridge","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sean Wallbridge"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/regroove.ca\/brainlitter\/2009\/08\/18\/how-to-use-excel-2007-to-separate-a-column-that-has-first-name-and-last-name-separated-by-a-space-into-two-separate-columns\/","url":"https:\/\/regroove.ca\/brainlitter\/2009\/08\/18\/how-to-use-excel-2007-to-separate-a-column-that-has-first-name-and-last-name-separated-by-a-space-into-two-separate-columns\/","name":"How to use Excel 2007 to separate a Column that has First Name and Last Name, separated by a space, into two separate columns - Brainlitter - Inside the mind of Sean Wallbridge","isPartOf":{"@id":"https:\/\/regroove.ca\/brainlitter\/#website"},"datePublished":"2009-08-18T14:56:00+00:00","dateModified":"2009-08-18T14:56:00+00:00","author":{"@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77"},"breadcrumb":{"@id":"https:\/\/regroove.ca\/brainlitter\/2009\/08\/18\/how-to-use-excel-2007-to-separate-a-column-that-has-first-name-and-last-name-separated-by-a-space-into-two-separate-columns\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/regroove.ca\/brainlitter\/2009\/08\/18\/how-to-use-excel-2007-to-separate-a-column-that-has-first-name-and-last-name-separated-by-a-space-into-two-separate-columns\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/regroove.ca\/brainlitter\/2009\/08\/18\/how-to-use-excel-2007-to-separate-a-column-that-has-first-name-and-last-name-separated-by-a-space-into-two-separate-columns\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Brainlitter","item":"https:\/\/regroove.ca\/brainlitter\/"},{"@type":"ListItem","position":2,"name":"How to use Excel 2007 to separate a Column that has First Name and Last Name, separated by a space, into two separate columns"}]},{"@type":"WebSite","@id":"https:\/\/regroove.ca\/brainlitter\/#website","url":"https:\/\/regroove.ca\/brainlitter\/","name":"Brainlitter - Inside the mind of Sean Wallbridge","description":"Dad. Husband. Drummer. Learner of Things.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/regroove.ca\/brainlitter\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77","name":"Sean Wallbridge","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g","caption":"Sean Wallbridge"},"url":"https:\/\/regroove.ca\/brainlitter\/author\/swallbridge\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/551"}],"collection":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/comments?post=551"}],"version-history":[{"count":0,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/551\/revisions"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/media?parent=551"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/categories?post=551"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/tags?post=551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}