{"id":65,"date":"2021-11-11T23:10:44","date_gmt":"2021-11-11T23:10:44","guid":{"rendered":"https:\/\/youcanfollow.me\/blog\/?p=65"},"modified":"2021-11-11T23:10:44","modified_gmt":"2021-11-11T23:10:44","slug":"how-to-split-google-sheets-column-into-2-columns","status":"publish","type":"post","link":"https:\/\/youcanfollow.me\/blog\/how-to-split-google-sheets-column-into-2-columns\/","title":{"rendered":"How to Split Google Sheets Column into 2 Columns"},"content":{"rendered":"<p>My love for Google Sheets grows more every day.<\/p>\n<p>Recently I had to split a list of names into first name and last name. I discovered that it&#8217;s *really* simple with Google Sheets. No complicated Excel formula to figure out&#8230; just a couple of mouse clicks and *presto*&#8230; you&#8217;re done.<\/p>\n<p>Here&#8217;s how:<\/p>\n<ol>\n<li style=\"list-style-type: none\">\n<ol>\n<li>Open your Google Sheets file.<img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-69 aligncenter\" src=\"https:\/\/youcanfollow.me\/blog\/wp-content\/uploads\/2021\/11\/googlesheets_split_data-1-262x300.gif\" alt=\"Google Sheet split column\" width=\"262\" height=\"300\" srcset=\"https:\/\/youcanfollow.me\/blog\/wp-content\/uploads\/2021\/11\/googlesheets_split_data-1-262x300.gif 262w, https:\/\/youcanfollow.me\/blog\/wp-content\/uploads\/2021\/11\/googlesheets_split_data-1-465x533.gif 465w, https:\/\/youcanfollow.me\/blog\/wp-content\/uploads\/2021\/11\/googlesheets_split_data-1-436x500.gif 436w\" sizes=\"auto, (max-width: 262px) 100vw, 262px\" \/><\/li>\n<li>Select the column you want to split.<\/li>\n<li>From the Data menu click on Split Text to Columns<img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-71 aligncenter\" src=\"https:\/\/youcanfollow.me\/blog\/wp-content\/uploads\/2021\/11\/googlesheets_split_data_menu-262x300.gif\" alt=\"Google Sheets Split Data\" width=\"262\" height=\"300\" srcset=\"https:\/\/youcanfollow.me\/blog\/wp-content\/uploads\/2021\/11\/googlesheets_split_data_menu-262x300.gif 262w, https:\/\/youcanfollow.me\/blog\/wp-content\/uploads\/2021\/11\/googlesheets_split_data_menu-465x533.gif 465w, https:\/\/youcanfollow.me\/blog\/wp-content\/uploads\/2021\/11\/googlesheets_split_data_menu-436x500.gif 436w\" sizes=\"auto, (max-width: 262px) 100vw, 262px\" \/><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none\">\n<ol>\n<li>Choose the &#8220;separator&#8221; and hit enter.<img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-76 aligncenter\" src=\"https:\/\/youcanfollow.me\/blog\/wp-content\/uploads\/2021\/11\/googlesheets_split_data_separator-2-300x195.gif\" alt=\"google sheets separator\" width=\"300\" height=\"195\" \/><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li>Done!<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-75 aligncenter\" src=\"https:\/\/youcanfollow.me\/blog\/wp-content\/uploads\/2021\/11\/googlesheets_split_data_complete-1-262x300.gif\" alt=\"Google Sheets columns\" width=\"262\" height=\"300\" srcset=\"https:\/\/youcanfollow.me\/blog\/wp-content\/uploads\/2021\/11\/googlesheets_split_data_complete-1-262x300.gif 262w, https:\/\/youcanfollow.me\/blog\/wp-content\/uploads\/2021\/11\/googlesheets_split_data_complete-1-465x533.gif 465w, https:\/\/youcanfollow.me\/blog\/wp-content\/uploads\/2021\/11\/googlesheets_split_data_complete-1-436x500.gif 436w\" sizes=\"auto, (max-width: 262px) 100vw, 262px\" \/><\/p>\n<p>Now simply download your file as a *.csv and it&#8217;s ready to import into your favorite software&#8230; like YouCanFollow.Me!<\/p>\n<p>Wait&#8230; what? You don&#8217;t have an account?<\/p>\n<p><a href=\"https:\/\/youcanfollow.me\">Sign up and get started for free!<\/a><\/p>\n<div class=\"fb-background-color\">\n\t\t\t  <div \n\t\t\t  \tclass = \"fb-comments\" \n\t\t\t  \tdata-href = \"https:\/\/youcanfollow.me\/blog\/how-to-split-google-sheets-column-into-2-columns\/\"\n\t\t\t  \tdata-numposts = \"10\"\n\t\t\t  \tdata-lazy = \"true\"\n\t\t\t\tdata-colorscheme = \"light\"\n\t\t\t\tdata-order-by = \"social\"\n\t\t\t\tdata-mobile=true>\n\t\t\t  <\/div><\/div>\n\t\t  <style>\n\t\t    .fb-background-color {\n\t\t\t\tbackground: #ffffff !important;\n\t\t\t}\n\t\t\t.fb_iframe_widget_fluid_desktop iframe {\n\t\t\t    width: 100% !important;\n\t\t\t}\n\t\t  <\/style>\n\t\t  ","protected":false},"excerpt":{"rendered":"<p>My love for Google Sheets grows more every day. Recently I had to split a list of names into first name and last name. I discovered that it&#8217;s *really* simple with Google Sheets. No complicated Excel formula to figure out&#8230; just a couple of mouse clicks and *presto*&#8230; you&#8217;re done. Here&#8217;s how: Open your Google &#8230; <a title=\"How to Split Google Sheets Column into 2 Columns\" class=\"read-more\" href=\"https:\/\/youcanfollow.me\/blog\/how-to-split-google-sheets-column-into-2-columns\/\" aria-label=\"More on How to Split Google Sheets Column into 2 Columns\">Read more<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-65","post","type-post","status-publish","format-standard","hentry","category-ycfm-features"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/youcanfollow.me\/blog\/wp-json\/wp\/v2\/posts\/65","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/youcanfollow.me\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/youcanfollow.me\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/youcanfollow.me\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/youcanfollow.me\/blog\/wp-json\/wp\/v2\/comments?post=65"}],"version-history":[{"count":4,"href":"https:\/\/youcanfollow.me\/blog\/wp-json\/wp\/v2\/posts\/65\/revisions"}],"predecessor-version":[{"id":79,"href":"https:\/\/youcanfollow.me\/blog\/wp-json\/wp\/v2\/posts\/65\/revisions\/79"}],"wp:attachment":[{"href":"https:\/\/youcanfollow.me\/blog\/wp-json\/wp\/v2\/media?parent=65"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/youcanfollow.me\/blog\/wp-json\/wp\/v2\/categories?post=65"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/youcanfollow.me\/blog\/wp-json\/wp\/v2\/tags?post=65"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}