{"id":30525,"date":"2023-08-23T21:33:04","date_gmt":"2023-08-23T19:33:04","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=30525"},"modified":"2024-04-11T19:23:14","modified_gmt":"2024-04-11T17:23:14","slug":"split-cells-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/split-cells-in-excel\/","title":{"rendered":"How to Split Cells in Excel &#8211; The Easy Way"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/F9E82DDC-C7C2-4EA1-A727-E6A163C91804.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30526 size-large\" title=\"How to Split Cells in Excel - The Easy Way\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/F9E82DDC-C7C2-4EA1-A727-E6A163C91804-1024x576.png\" alt=\"How to Split Cells in Excel - The Easy Way\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/F9E82DDC-C7C2-4EA1-A727-E6A163C91804-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/F9E82DDC-C7C2-4EA1-A727-E6A163C91804-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/F9E82DDC-C7C2-4EA1-A727-E6A163C91804-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/F9E82DDC-C7C2-4EA1-A727-E6A163C91804.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/split-cells-in-excel\/#Why_Split_Cells_in_Excel\" title=\"Why Split Cells in Excel?\">Why Split Cells in Excel?<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/split-cells-in-excel\/#Scenarios_Where_Cell_Splitting_Is_Useful\" title=\"Scenarios Where Cell Splitting Is Useful\">Scenarios Where Cell Splitting Is Useful<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Why_Split_Cells_in_Excel\"><\/span>Why Split Cells in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-split-cells-in-excel\/\" target=\"_blank\" rel=\"noopener\">Splitting cells<\/a> is vital for better data organization and analysis. It breaks down combined data into separate parts, simplifying filtering, sorting, and analysis. Whether it&#8217;s names, addresses, dates, or structured info, cell splitting enhances data clarity and usability.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Scenarios_Where_Cell_Splitting_Is_Useful\"><\/span>Scenarios Where Cell Splitting Is Useful<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>Creating employee timetables<\/li>\n<li>Full Names: Splitting full names into first and last names for personalized communication and sorting.<\/li>\n<li>Addresses: Dividing addresses into street, city, state, and zip code for efficient mapping and analysis.<\/li>\n<li>Dates and Times: Separating date and time information into individual cells for accurate calculations.<\/li>\n<li>Keywords or Tags: Extracting individual keywords or tags from a single cell for better categorization.<\/li>\n<\/ul>\n<p>You might also want to check out this article on the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-20-common-excel-problems-solved\/\" target=\"_blank\" rel=\"noopener\">Top 20 Common Problems in Excel<\/a>! Don\u2019t forget to take advantage of this <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\">Free Microsoft Excel Online Course \u2013 20+ Hours Beginner to Advanced Course<\/a>!<\/p>\n<p>Download the Excel Workbook below to follow along and understand how to Split Cells in Excel \u2013<br \/>\n<a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Split-Cells-1.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel workbook<\/strong>\u00a0<\/span><span class=\"postTitle px-3\">Split-Cells-1.xlsx<\/span><\/a><\/p>\n<p>Now, let&#8217;s explore each of these steps individually!<\/p>\n<h3><strong><span id=\"1\" style=\"color: #ff0000\">Splitting a Single Cell<\/span><\/strong><\/h3>\n<p>To perform cell splitting in Excel, introduce a fresh column, modify column widths, and then combine cells as needed.<\/p>\n<p>For this example, we want to create an employee timetable. Susan Forst and Aaron Torres start their shift at 8:00AM and 10:00AM, respectively. David Seed, however, starts his shift at 8:30AM. How do we showcase this on our <a class=\"wpil_keyword_link\" title=\"spreadsheet\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\" data-wpil-keyword-link=\"linked\">spreadsheet<\/a>?<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-12.54.28-AM.jpeg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30530\" title=\"How to Split Cells in Excel - The Easy Way\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-12.54.28-AM-1024x278.jpeg\" alt=\"How to Split Cells in Excel - The Easy Way\" width=\"1024\" height=\"278\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-12.54.28-AM-1024x278.jpeg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-12.54.28-AM-300x81.jpeg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-12.54.28-AM-768x208.jpeg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-12.54.28-AM-1536x417.jpeg 1536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-12.54.28-AM-2048x556.jpeg 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>Select <strong>Column C<\/strong>.<\/p>\n<p><strong>Right click<\/strong>, then select <strong>Insert<\/strong>.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-12.55.36-AM.jpeg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30531\" title=\"How to Split Cells in Excel - The Easy Way\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-12.55.36-AM-1024x558.jpeg\" alt=\"How to Split Cells in Excel - The Easy Way\" width=\"1024\" height=\"558\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-12.55.36-AM-1024x558.jpeg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-12.55.36-AM-300x163.jpeg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-12.55.36-AM-768x418.jpeg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-12.55.36-AM-1536x837.jpeg 1536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-12.55.36-AM.jpeg 1726w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>By default, column width is set at 64 pixels. Adjust the width of <strong>columns B and C to 32 pixels<\/strong>.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-12.58.52-AM.jpeg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30532\" title=\"How to Split Cells in Excel - The Easy Way\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-12.58.52-AM-1024x391.jpeg\" alt=\"How to Split Cells in Excel - The Easy Way\" width=\"1024\" height=\"391\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-12.58.52-AM-1024x391.jpeg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-12.58.52-AM-300x115.jpeg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-12.58.52-AM-768x293.jpeg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-12.58.52-AM-1536x587.jpeg 1536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-12.58.52-AM.jpeg 1841w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p><strong>Select B1 and C1<\/strong>.<\/p>\n<p>Navigate to the <strong>Home<\/strong> tab, locate the <strong>Alignment<\/strong> group, and select the downward arrow adjacent to <strong>Merge &amp; Center<\/strong>. Proceed to choose the option labeled <strong>Merge Cells<\/strong>.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.00.42-AM.jpeg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30533\" title=\"How to Split Cells in Excel - The Easy Way\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.00.42-AM-1024x560.jpeg\" alt=\"How to Split Cells in Excel - The Easy Way\" width=\"1024\" height=\"560\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.00.42-AM-1024x560.jpeg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.00.42-AM-300x164.jpeg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.00.42-AM-768x420.jpeg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.00.42-AM-1536x841.jpeg 1536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.00.42-AM.jpeg 1599w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>Merge cells <strong>B2 and C2<\/strong>, and <strong>B4 and C4<\/strong>, as well.<\/p>\n<p>Alter the background color of cell B3 to <strong>No Fill<\/strong>.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.03.09-AM.jpeg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30534\" title=\"How to Split Cells in Excel - The Easy Way\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.03.09-AM-1024x563.jpeg\" alt=\"How to Split Cells in Excel - The Easy Way\" width=\"1024\" height=\"563\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.03.09-AM-1024x563.jpeg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.03.09-AM-300x165.jpeg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.03.09-AM-768x422.jpeg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.03.09-AM-1536x844.jpeg 1536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.03.09-AM.jpeg 1579w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>Voila! The employee timetable will now show the 30 minute increment.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.04.12-AM.jpeg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30535\" title=\"How to Split Cells in Excel - The Easy Way\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.04.12-AM-1024x367.jpeg\" alt=\"How to Split Cells in Excel - The Easy Way\" width=\"1024\" height=\"367\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.04.12-AM-1024x367.jpeg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.04.12-AM-300x107.jpeg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.04.12-AM-768x275.jpeg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.04.12-AM-1536x550.jpeg 1536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.04.12-AM.jpeg 1921w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<h3><strong><span id=\"2\" style=\"color: #ff0000\">Text to Column<\/span><\/strong><\/h3>\n<p>Using <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-text-to-columns\/\" target=\"_blank\" rel=\"noopener\">Excel&#8217;s <strong>Text to Columns<\/strong><\/a>\u00a0feature to split cells is a handy method to divide data within a cell into multiple columns using a delimiter like a comma, space, or tab. Here&#8217;s how:<\/p>\n<p>Start by selecting the range of cells that you want to split. This can be a single column or a range of columns.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.14.39-AM.jpeg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30537\" title=\"How to Split Cells in Excel - The Easy Way\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.14.39-AM-1024x471.jpeg\" alt=\"How to Split Cells in Excel - The Easy Way\" width=\"1024\" height=\"471\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.14.39-AM-1024x471.jpeg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.14.39-AM-300x138.jpeg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.14.39-AM-768x354.jpeg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.14.39-AM.jpeg 1525w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>Go to the <strong>Data<\/strong> tab in the Excel ribbon. Click <strong>Text to Column<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.15.41-AM.jpeg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30538\" title=\"How to Split Cells in Excel - The Easy Way\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.15.41-AM-1024x552.jpeg\" alt=\"How to Split Cells in Excel - The Easy Way\" width=\"1024\" height=\"552\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.15.41-AM-1024x552.jpeg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.15.41-AM-300x162.jpeg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.15.41-AM-768x414.jpeg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.15.41-AM-1536x828.jpeg 1536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.15.41-AM-2048x1104.jpeg 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>In the <strong>Convert Text to Columns Wizard<\/strong>, you&#8217;ll have the option to choose between &#8220;<strong>Delimited<\/strong>&#8221; and &#8220;Fixed width.&#8221; Since you want to split cells based on a specific delimiter, choose <strong>Delimited<\/strong> and click <strong>Next<\/strong>.<\/p>\n<p>Choose the delimiter that separates the data within your cells. Common options include comma, tab, semicolon, space, etc. You can also select multiple delimiters if needed. In our case, we will select Space.<\/p>\n<p>You&#8217;ll be prompted to select where you want the split data to be placed. You can choose to replace the original data or specify a new location (either a new column or a different sheet). In our case, let\u2019s specify <strong>$B$2<\/strong> as the location.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.21.06-AM.jpeg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30539\" title=\"How to Split Cells in Excel - The Easy Way\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.21.06-AM-1024x562.jpeg\" alt=\"How to Split Cells in Excel - The Easy Way\" width=\"1024\" height=\"562\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.21.06-AM-1024x562.jpeg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.21.06-AM-300x165.jpeg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.21.06-AM-768x421.jpeg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.21.06-AM-1536x843.jpeg 1536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.21.06-AM.jpeg 2038w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>The preview section at the bottom of the wizard will show you how your data will be split based on your chosen delimiter. If the preview looks correct, click the &#8220;Finish&#8221; button.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.22.28-AM.jpeg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30540\" title=\"How to Split Cells in Excel - The Easy Way\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.22.28-AM-1024x478.jpeg\" alt=\"How to Split Cells in Excel - The Easy Way\" width=\"1024\" height=\"478\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.22.28-AM-1024x478.jpeg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.22.28-AM-300x140.jpeg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.22.28-AM-768x358.jpeg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.22.28-AM.jpeg 1528w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<h3><strong><span id=\"3\" style=\"color: #ff0000\">Text Functions<\/span><\/strong><\/h3>\n<p>This method is useful when you want to split a cell&#8217;s content using specific rules or conditions.<\/p>\n<ul>\n<li>For the first name: <strong>=LEFT(A1, FIND(&#8221; &#8220;, A1) &#8211; 1)<\/strong><\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.43.13-AM.jpeg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30541\" title=\"How to Split Cells in Excel - The Easy Way\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.43.13-AM-1024x480.jpeg\" alt=\"How to Split Cells in Excel - The Easy Way\" width=\"1024\" height=\"480\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.43.13-AM-1024x480.jpeg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.43.13-AM-300x141.jpeg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.43.13-AM-768x360.jpeg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.43.13-AM.jpeg 1515w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<ul>\n<li>For the last name: <strong>=RIGHT(A1, LEN(A1) &#8211; FIND(&#8221; &#8220;, A1))<\/strong><\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.44.37-AM.jpeg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30542\" title=\"How to Split Cells in Excel - The Easy Way\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.44.37-AM-1024x475.jpeg\" alt=\"How to Split Cells in Excel - The Easy Way\" width=\"1024\" height=\"475\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.44.37-AM-1024x475.jpeg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.44.37-AM-300x139.jpeg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.44.37-AM-768x356.jpeg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.44.37-AM.jpeg 1532w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>Select the range <strong>B2 and C2<\/strong>, <strong>drag from the bottom right hand corner<\/strong> to apply the <a class=\"wpil_keyword_link\" title=\"formulas\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" data-wpil-keyword-link=\"linked\">formulas<\/a> to the rest of the employees.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.46.41-AM.jpeg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30543\" title=\"How to Split Cells in Excel - The Easy Way\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.46.41-AM-1024x526.jpeg\" alt=\"How to Split Cells in Excel - The Easy Way\" width=\"1024\" height=\"526\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.46.41-AM-1024x526.jpeg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.46.41-AM-300x154.jpeg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.46.41-AM-768x395.jpeg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.46.41-AM-1536x789.jpeg 1536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.46.41-AM.jpeg 1586w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>These formulas locate the space character&#8217;s position and extract the relevant part of the text. Your choice of method should match your data and needs. Text to Columns is best for basic delimiter-based splits, while text functions offer more control for intricate divisions.<\/p>\n<h3><strong><span id=\"4\" style=\"color: #ff0000\">Flash Fill<\/span><\/strong><\/h3>\n<p>Suppose you want to split data into separate columns for <strong>first names<\/strong>, <strong>last names<\/strong>, and their respective <strong>departments<\/strong>.<\/p>\n<p>Enter the full names in a column (e.g., Column A).<\/p>\n<p>In an adjacent column (e.g., Column B), start typing the pattern you want Excel to recognize for splitting. In cell <strong>B2<\/strong>, type \u201c<strong>Susan<\/strong>.\u201d In cell <strong>C2<\/strong>, type the last name \u201c<strong>Forst<\/strong>.\u201d In cell D2, type \u201c<strong>Accounting<\/strong>.\u201d<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.59.32-AM.jpeg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30544\" title=\"How to Split Cells in Excel - The Easy Way\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.59.32-AM-1024x386.jpeg\" alt=\"How to Split Cells in Excel - The Easy Way\" width=\"1024\" height=\"386\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.59.32-AM-1024x386.jpeg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.59.32-AM-300x113.jpeg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.59.32-AM-768x289.jpeg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.59.32-AM-1536x579.jpeg 1536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.59.32-AM.jpeg 1611w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p><strong>Highlight cell B2<\/strong>, and press <strong>CTRL + E<\/strong> (Flash Fill <a class=\"wpil_keyword_link\" title=\"shortcut\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/\" target=\"_blank\" rel=\"noopener\" data-wpil-keyword-link=\"linked\">shortcut<\/a>).<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.59.58-AM.jpeg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30545\" title=\"How to Split Cells in Excel - The Easy Way\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.59.58-AM-1024x455.jpeg\" alt=\"How to Split Cells in Excel - The Easy Way\" width=\"1024\" height=\"455\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.59.58-AM-1024x455.jpeg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.59.58-AM-300x133.jpeg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.59.58-AM-768x341.jpeg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.59.58-AM-1536x682.jpeg 1536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-1.59.58-AM.jpeg 1616w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p><strong>Highlight cell C2<\/strong>, and press <strong>CTRL + E<\/strong> (Flash Fill shortcut).<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-2.00.21-AM.jpeg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30546\" title=\"How to Split Cells in Excel - The Easy Way\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-2.00.21-AM-1024x418.jpeg\" alt=\"How to Split Cells in Excel - The Easy Way\" width=\"1024\" height=\"418\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-2.00.21-AM-1024x418.jpeg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-2.00.21-AM-300x123.jpeg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-2.00.21-AM-768x314.jpeg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-2.00.21-AM-1536x627.jpeg 1536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-2.00.21-AM.jpeg 1616w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p><strong>Highlight cell D2<\/strong>, and press <strong>CTRL + E<\/strong> (Flash Fill shortcut).<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-2.00.40-AM.jpeg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30547\" title=\"How to Split Cells in Excel - The Easy Way\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-2.00.40-AM-1024x400.jpeg\" alt=\"How to Split Cells in Excel - The Easy Way\" width=\"1024\" height=\"400\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-2.00.40-AM-1024x400.jpeg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-2.00.40-AM-300x117.jpeg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-2.00.40-AM-768x300.jpeg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-2.00.40-AM-1536x600.jpeg 1536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Screenshot-2023-08-14-at-2.00.40-AM.jpeg 1674w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>Excel will attempt to recognize the pattern and fill in the rest of the column automatically.<\/p>\n<p>Below you will find 120+ Excel formulas &amp; functions examples for key formulas &amp; functions like XLOOKUP, VLOOKUP, INDEX, MATCH, IF, SUMPRODUCT, AVERAGE, SUBTOTAL, OFFSET, LOOKUP, ROUND, COUNT, SUMIFS, ARRAY, FIND, TEXT, and many more.\u00a0 <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-admin\/post.php?post=28162&amp;action=edit\" target=\"_blank\">Let us start learning for free!<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Why Split Cells in Excel? Splitting cells is vital for better data organization and analysis. It breaks down combined data into separate parts, simplifying filtering, sorting, and analysis. Whether it&#8217;s names, addresses, dates, or structured info, cell splitting enhances data clarity and usability. Scenarios Where Cell Splitting Is Useful Creating employee timetables Full Names: Splitting [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":30526,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"How to Split Cells in Excel - The Easy Way","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[3,10,300,305],"tags":[162,1327,1328,1326],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/30525"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=30525"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/30525\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/30526"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=30525"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=30525"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=30525"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}