{"id":2810,"date":"2020-12-19T11:41:37","date_gmt":"2020-12-19T19:41:37","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=2810"},"modified":"2020-12-19T11:41:38","modified_gmt":"2020-12-19T19:41:38","slug":"how-to-split-a-text-into-multi-columns-on-excel","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=2810","title":{"rendered":"How to Split a Text into Multi-columns on Excel"},"content":{"rendered":"\n<p>What if you want to split out information that&#8217;s in one cell into two different cells? For example, maybe you want to pull out someone&#8217;s company name through their email address. Or perhaps you want to separate someone&#8217;s full name into a first and last name for your email marketing templates.<\/p>\n\n\n\n<p>Thanks to Excel, both are possible. First, highlight the column that you want to split up. Next, go to the Data tab and select &#8220;Text to Columns.&#8221; A module will appear with additional information.<\/p>\n\n\n\n<p>First, you need to select either &#8220;Delimited&#8221; or &#8220;Fixed Width.&#8221;<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>&#8220;Delimited&#8221; means you want to break up the column based on characters such as commas, spaces, or tabs.<\/li><li>&#8220;Fixed Width&#8221; means you want to select the exact location on all the columns that you want the split to occur.<\/li><\/ul>\n\n\n\n<p>In the example case below, let&#8217;s select &#8220;Delimited&#8221; so we can separate the full name into first name and last name.<\/p>\n\n\n\n<p>Then, it&#8217;s time to choose the Delimiters. This could be a tab, semi-colon, comma, space, or something else. (&#8220;Something else&#8221; could be the &#8220;@&#8221; sign used in an email address, for example.) In our example, let&#8217;s choose the space. Excel will then show you a preview of what your new columns will look like.<\/p>\n\n\n\n<p>When you&#8217;re happy with the preview, press &#8220;Next.&#8221; This page will allow you to select Advanced Formats if you choose to. When you&#8217;re done, click &#8220;Finish.&#8221;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/blog.hubspot.com\/hs-fs\/hub\/53\/file-2420726051-gif\/Text_to_Column_GIF.gif?width=600&amp;name=Text_to_Column_GIF.gif\" alt=\"Text to Column in Excel\" title=\"Text to Column\"\/><\/figure>\n\n\n\n<p>Ref: https:\/\/blog.hubspot.com\/marketing\/how-to-use-excel-tips<\/p>\n","protected":false},"excerpt":{"rendered":"<p>What if you want to split out information that&#8217;s in one cell into two different cells? For example, maybe you want to pull out someone&#8217;s company name through their email address. Or perhaps you want to separate someone&#8217;s full name into a first and last name for your email marketing templates. Thanks to Excel, both <a class=\"read-more\" href=\"https:\/\/SUMMALAI.COM\/?p=2810\">Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,18],"tags":[505,504],"class_list":["post-2810","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-office","tag-split-text","tag-split-text-on-excel"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/2810","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2810"}],"version-history":[{"count":1,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/2810\/revisions"}],"predecessor-version":[{"id":2811,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/2810\/revisions\/2811"}],"wp:attachment":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2810"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2810"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2810"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}