How to Split Cells in Excel
How to Split Cells in Excel GA S REGULAR Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps > MS Office
In the example below, you can see the cell contains a semicolon between each piece of information. This semicolon lets you split those individual elements into other cells. Select the cells you want to split. Select Data from the menu and select Text to Columns from the ribbon. Select the Delimited radio button from the pop-up window and select the Next button. Select the appropriate delimiter character (in this example, semicolon), and select the Next button. You will see a preview of what the output cells will look like. If none of the listed delimiters works for your situation, you can select Other and type the delimiter in the text box. Also if your delimiter character is in multiples (like spaces), you can select the checkbox next to Treat consecutive delimiters as one. In this final window, you can choose the format for your output cells, as well as the destination for your newly split cells. Select the Finish button when you're done. Finally, you'll see the results in your main spreadsheet. If you've set up everything right, your original cell will split perfectly across multiple cells.
How to Split Cells in Excel
There are several ways to do it
By Ryan Dube Ryan Dube Writer University of Maine Ryan Dube is a freelance contributor to Lifewire and former Managing Editor of MakeUseOf, senior IT Analyst, and an automation engineer. lifewire's editorial guidelines Updated on April 20, 2022 Reviewed by Ryan Perian Reviewed by Ryan Perian Western Governors University Ryan Perian is a certified IT specialist who holds numerous IT certifications and has 12+ years' experience working in the IT industry support and management positions. lifewire's editorial guidelines Tweet Share Email Tweet Share Email MS Office Excel Word Powerpoint OutlookWhat to Know
Use Convert Text to Columns or Flash Fill to split a selected cell.Use Left and Right Excel functions to split one cell into two.Merge & Center lets you span one cell across multiple adjacent cells. This article explains how to split a cell in Excel into individual cells.How Do I Split a Cell Into Multiple Cells
There are several ways to split a cell into multiple cells, depending on the content of the cell you want to split.Split a Cell With Convert Text to Columns
You need to determinate a pattern in order to split a cell. This pattern would be some delimiter like a comma, semicolon, or colon.In the example below, you can see the cell contains a semicolon between each piece of information. This semicolon lets you split those individual elements into other cells. Select the cells you want to split. Select Data from the menu and select Text to Columns from the ribbon. Select the Delimited radio button from the pop-up window and select the Next button. Select the appropriate delimiter character (in this example, semicolon), and select the Next button. You will see a preview of what the output cells will look like. If none of the listed delimiters works for your situation, you can select Other and type the delimiter in the text box. Also if your delimiter character is in multiples (like spaces), you can select the checkbox next to Treat consecutive delimiters as one. In this final window, you can choose the format for your output cells, as well as the destination for your newly split cells. Select the Finish button when you're done. Finally, you'll see the results in your main spreadsheet. If you've set up everything right, your original cell will split perfectly across multiple cells.