{"id":386,"date":"2022-05-19T16:24:47","date_gmt":"2022-05-19T10:54:47","guid":{"rendered":"https:\/\/sheetstips.com\/?p=386"},"modified":"2022-05-21T11:56:08","modified_gmt":"2022-05-21T06:26:08","slug":"split-text-to-columns-google-sheets","status":"publish","type":"post","link":"https:\/\/sheetstips.com\/split-text-to-columns-google-sheets\/","title":{"rendered":"How to Split Text to Columns in Google Sheets: Split Cell Horizontally\/Vertically"},"content":{"rendered":"<p><strong>Split Text to Columns<\/strong>: When working with a huge dataset in Google Sheets, it&#8217;s common to squish the data. <strong>Split text to columns<\/strong> is one of the most useful features which was recently added in Google Sheets, that helps to split the data into columns. You can split data in the Google Sheets by any of the two methods via Formula or through an in-built function. On this page, let&#8217;s explore how to split the data from one column to multiple columns with important <strong><a href=\"https:\/\/sheetstips.com\/google-sheets-tips\/\" target=\"_blank\" rel=\"noopener\">Google Sheet tips<\/a><\/strong>. Read on to find out more.<\/p>\n<table>\n<tbody>\n<tr>\n<td>\n<p style=\"text-align: center;\"><strong>Table of Contents<\/strong><\/p>\n<ul>\n<li><a href=\"#Split-Cells-in-Google-Sheets\">Split Cells in Google Sheets<\/a><\/li>\n<li><a href=\"#Split-Cells-in-Google-Sheets-to-Multiple-Columns\">Split Cells in Google Sheets to Multiple Columns<\/a><\/li>\n<li><a href=\"#Split-Email-ID-into-User-Name-&amp;-Domain-Name-in-Google-Sheets\">Split Email ID into User Name &amp; Domain Name in Google Sheets<\/a><\/li>\n<li><a href=\"#Split-Domain-Name-from-URL-to-Cells-in-Google-Sheets\">Split Domain Name from URL to Cells in Google Sheets<\/a><\/li>\n<li><a href=\"#Google-Sheets-Split-Text-to-Columns-Formula\">Google Sheets Split Text to Columns Formula<\/a><\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"Split-Cells-in-Google-Sheets\">Split Cells in Google Sheets<\/h2>\n<p>When you need to quickly split the first and last name, or the username and domain name from an email id or the domain name from URLs, the Split Text to Columns tool come in handy. Let&#8217;s understand how this can be done with the help of examples.<\/p>\n<h3 id=\"Split-Cells-in-Google-Sheets-to-Multiple-Columns\">Split Cells in Google Sheets to Multiple Columns<\/h3>\n<p>Now, let&#8217;s split the first name and last name from one column to multiple columns with an example.<\/p>\n<ul>\n<li><strong>Step 1:<\/strong> Select the cells where you would like to split the text into columns.<\/li>\n<li><strong>Step 2:<\/strong> Click on &#8220;<strong>Data<\/strong>&#8221; from the menubar and select &#8220;<strong>Split text to columns<\/strong>&#8221; from the drop-down menu.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-387\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns.png\" alt=\"split text to columns\" width=\"988\" height=\"555\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns.png 988w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns-300x169.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns-768x431.png 768w\" sizes=\"(max-width: 988px) 100vw, 988px\" \/><\/p>\n<ul>\n<li><strong>Step 3:<\/strong> A separator dialog box will open the screen. Now click on the separator dialog box.<\/li>\n<li><strong>Step 4:<\/strong> Select &#8220;<strong>space<\/strong>&#8221; from the dropdown menu as the delimiter.<\/li>\n<\/ul>\n<p>Now you will see the cells results as shown in the image below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-388 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns1.png\" alt=\"split text to columns\" width=\"695\" height=\"391\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns1.png 695w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns1-300x169.png 300w\" sizes=\"(max-width: 695px) 100vw, 695px\" \/><\/p>\n<ul>\n<li>When you use the \u2018Split Text to Column&#8217; command, the original data set is overwritten. Create a copy of the data set and use Split Text to Column on that data set if you wish to preserve the original dataset intact.<\/li>\n<li>The above method gives static results. This means that if you update the source dataset, your data will not be updated. Use the split function if you want this to be dynamic<\/li>\n<li>Each space character is viewed as a distinct separator. If there is a double space between names and the space character has been used as a delimiter, the name will be split into three columns. In such circumstances, use the TRIM function to remove the extra space.<\/li>\n<\/ul>\n<h3 id=\"Split-Email-ID-into-User-Name-&amp;-Domain-Name-in-Google-Sheets\">Split Email ID into User Name &amp; Domain Name in Google Sheets<\/h3>\n<p>With the help of the <strong>Split text to columns<\/strong> feature in Google Sheets, we can easily split the user name and domain name from the email id. The steps to split the username and domain name from the email are given below:<\/p>\n<ul>\n<li><strong>Step 1:<\/strong> Select the email ids where you would like to split the usernames and domain names.<\/li>\n<li><strong>Step 2:<\/strong> Now click on &#8220;<strong>Data<\/strong>&#8221; from the menubar and select &#8220;<strong>Split text to columns<\/strong>&#8221; from the drop-down menu.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-389 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns3.png\" alt=\"split text to columns\" width=\"987\" height=\"555\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns3.png 987w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns3-300x169.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns3-768x432.png 768w\" sizes=\"(max-width: 987px) 100vw, 987px\" \/><\/p>\n<ul>\n<li><strong>Step 3:<\/strong> A <strong>Separator dialog box<\/strong> will open on the screen. Click on the Separator dialog box and select &#8220;<strong>Custom<\/strong>&#8221; from the drop-down menu.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-390 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns4.png\" alt=\"split text to columns\" width=\"861\" height=\"485\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns4.png 861w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns4-300x169.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns4-768x433.png 768w\" sizes=\"(max-width: 861px) 100vw, 861px\" \/><\/p>\n<ul>\n<li><strong>Step 4:<\/strong> Now in the custom field, enter the &#8220;<strong>@<\/strong>&#8221; symbol. You will instantly see the domain name and username separated as shown below.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-391 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns5.png\" alt=\"split text to columns\" width=\"519\" height=\"233\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns5.png 519w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns5-300x135.png 300w\" sizes=\"(max-width: 519px) 100vw, 519px\" \/><\/p>\n<ul>\n<li><a href=\"https:\/\/sheetstips.com\/merge-cells-google-sheets\/\">How to Quickly Merge Cells in Google Sheets: Merge &amp; Unmerge Without Losing Data<\/a><\/li>\n<li><a href=\"https:\/\/sheetstips.com\/transpose-data-google-sheets\/\">How to Quickly Transpose Data in Google Sheets: TRANSPOSE, Paste Special Method<\/a><\/li>\n<li><a href=\"https:\/\/sheetstips.com\/dependent-drop-list-google-sheets\/\">How to Create a Dependent Drop Down List in Google Sheets: Multiple Drop Down List<\/a><\/li>\n<\/ul>\n<h3 id=\"Split-Domain-Name-from-URL-to-Cells-in-Google-Sheets\">Split Domain Name from URL to Cells in Google Sheets<\/h3>\n<p>This inbuilt split feature also helps us to split the domain name from the URL in Google Sheet. Let&#8217;s consider the following dataset to split the domain name from URL.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-392 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns6.png\" alt=\"split text to columns\" width=\"314\" height=\"172\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns6.png 314w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns6-300x164.png 300w\" sizes=\"(max-width: 314px) 100vw, 314px\" \/><\/p>\n<p>The steps to split or divide the domain name from the URL are given below:<\/p>\n<ul>\n<li><strong>Step 1:<\/strong> Select the cell range where you would like to split the domain name from the URL.<\/li>\n<li><strong>Step 2:<\/strong> Now click on the &#8220;<strong>Data<\/strong>&#8221; from the toolbar and select &#8220;<strong>Split text into Columns<\/strong>&#8220;.<\/li>\n<li><strong>Step 3:<\/strong> In the Separator Dialog box, select &#8220;<strong>Custom<\/strong>&#8221; from the drop-down menu.<\/li>\n<li><strong>Step 4:<\/strong> Now in the &#8220;<strong>Custom field<\/strong>&#8221; enter &#8220;<strong>\/<\/strong>&#8220;. The results will be displayed on the screen as shown below.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-393 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns7.png\" alt=\"split text to columns\" width=\"525\" height=\"208\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns7.png 525w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns7-300x119.png 300w\" sizes=\"(max-width: 525px) 100vw, 525px\" \/><\/p>\n<p>If you&#8217;re wondering why column B is blank, it&#8217;s because, in the URLs, there are two forward slashes following HTTP. Each forward slash is considered a separate separator.<\/p>\n<p>Also, keep in mind that this strategy only works if the domain names are in the same format. If you have one with HTTP and one without, for example, the domain names may appear in different columns.<\/p>\n<p>If you wish to split the text into rows rather than columns, one simple method is to use text to columns first, then<strong> <a href=\"https:\/\/sheetstips.com\/transpose-data-google-sheets\/\" target=\"_blank\" rel=\"noopener\">transpose the data<\/a><\/strong> in Google Sheets.<\/p>\n<h3 id=\"Google-Sheets-Split-Text-to-Columns-Formula\">Google Sheets Split Text to Columns Formula<\/h3>\n<p>We can also use the Split formula to split or divide the text into columns in Google Sheets. The steps to split the text into columns using the Split formula are given below:<\/p>\n<ul>\n<li><strong>Step 1:<\/strong> Select the cells where you want to split the data.<\/li>\n<li><strong>Step 2:<\/strong> Now enter the formula as <strong>=SPLIT(A2,&#8221; &#8220;)<\/strong>.<\/li>\n<li><strong>Step 3:<\/strong> Press the &#8220;<strong>Enter<\/strong>&#8221; button. You will see the results.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-394 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns-using-formula.png\" alt=\"split text to columns using formula\" width=\"418\" height=\"218\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns-using-formula.png 418w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns-using-formula-300x156.png 300w\" sizes=\"(max-width: 418px) 100vw, 418px\" \/><\/p>\n<p>In order to split the data into all the cells, just drag the cell where you have applied the formula. The formula will be applied to all the cells and data will be split into all the cells.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Split Text to Columns: When working with a huge dataset in Google Sheets, it&#8217;s common to squish the data. Split text to columns is one of the most useful features which was recently added in Google Sheets, that helps to split the data into columns. You can split data in the Google Sheets by any &#8230; <a title=\"How to Split Text to Columns in Google Sheets: Split Cell Horizontally\/Vertically\" class=\"read-more\" href=\"https:\/\/sheetstips.com\/split-text-to-columns-google-sheets\/\" aria-label=\"More on How to Split Text to Columns in Google Sheets: Split Cell Horizontally\/Vertically\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[100,99],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1601,"url":"https:\/\/sheetstips.com\/convert-a-row-to-a-column-or-backwards-in-google-docs-spreadsheets\/","url_meta":{"origin":386,"position":0},"title":"How to Convert Rows to Columns or Backwards in Google Sheets?","author":"Varsha","date":"May 14, 2022","format":false,"excerpt":"When a user is dealing with a large number of Spreadsheets, it is quite common for one to convert rows to columns or backward. Google Sheets allows users to convert rows to columns and column to rows using Google Transpose Function. As the name suggests, the Transpose Function in Google\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"convert-a-row-to-a-column-or-backwards-in-google-docs-spreadsheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/11\/convert-a-row-to-a-column-or-backwards-in-google-docs-spreadsheets.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1564,"url":"https:\/\/sheetstips.com\/how-to-divide-numbers-in-google-sheets\/","url_meta":{"origin":386,"position":1},"title":"How to Divide in Google Sheets? (Divide Numbers, Columns, Rows, Multiple Cells)","author":"Varsha","date":"May 14, 2022","format":false,"excerpt":"Google Sheets is one the most popular software when it comes to collaborating with multiple users and performing mathematical calculations. The division is one of the most important basic mathematical operations with the help of which we can perform various mathematical operations. In this article, we have provided all the\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"how-to-divide-numbers-in-google-sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-divide-in-google-sheets1.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":510,"url":"https:\/\/sheetstips.com\/format-painter-google-sheets\/","url_meta":{"origin":386,"position":2},"title":"Format Painter in Google Sheets: Copy Paste Text and Images","author":"Varsha","date":"December 5, 2022","format":false,"excerpt":"Format Painter in Google Sheets: When dealing with Google Sheets, we frequently format data to make it seem appealing and more understandable. To help with this, Google Sheets offers us a tool that makes copy-pasting format easy. Format Painter tool is the tool that makes the copy-paste format easy. You\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"Format-Painter-icon-in-toolbar1","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/08\/Format-Painter-icon-in-toolbar1-2.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":593,"url":"https:\/\/sheetstips.com\/group-columns-google-sheets\/","url_meta":{"origin":386,"position":3},"title":"How to Group Columns in Google Sheets? (Group Multiple Columns, Collapse)","author":"Varsha","date":"May 18, 2022","format":false,"excerpt":"When working in Google Sheets, we need to organize our data to make it more readable. One of the ways to organize the dataset in Google Sheets is to make use of the Group Columns feature. With the help of this feature, we can easily group a set of columns\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"group columns in google sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/08\/group-mulitple-columns-google-sheets4-1.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":852,"url":"https:\/\/sheetstips.com\/google-sheets-hide-columns-from-certain-users\/","url_meta":{"origin":386,"position":4},"title":"How to Hide Columns from Certain Users in Google Sheets (3 Easy Methods)","author":"Varsha","date":"May 17, 2022","format":false,"excerpt":"When you are working with Google Sheets which needs to be shared with multiple users, you might fall under a situation where you might want to hide columns from certain users which is impossible. However, there are few hacks with the help of which you can hide the columns in\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"hide columns in google sheets6","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/09\/hide-columns-in-google-sheets6.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":2125,"url":"https:\/\/sheetstips.com\/how-to-find-matching-terms-in-google-sheets\/","url_meta":{"origin":386,"position":5},"title":"How To Find Matching Terms in Google Sheets? &#8211; Google Sheet Match Multiple Criteria","author":"Varsha","date":"May 22, 2022","format":false,"excerpt":"It's no wonder that Google Sheets allows users to perform various operations using the functions and formulas available on Google Sheets. Similarly, in this article, let us consider an example where we want to construct a single-cell formula that accepts a string of search terms and returns all of the\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"matching terms in google sheets1","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/02\/matching-terms-in-google-sheets1.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/386"}],"collection":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/comments?post=386"}],"version-history":[{"count":1,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/386\/revisions"}],"predecessor-version":[{"id":2423,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/386\/revisions\/2423"}],"wp:attachment":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/media?parent=386"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/categories?post=386"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/tags?post=386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}