How to split text into two columns in excel

Separating items in a cell in Excel can seem tricky, but it’s actually quite simple once you know the right tools to use. In just a few steps, you can split data in a single cell into multiple cells using Excel’s built-in features.

You’ll primarily rely on the Text to Columns feature, which allows you to divide your data based on delimiters like commas, spaces, or tabs.

How to separate data in excel using formula

How to Separate Items in a Cell in Excel

Using the Text to Columns feature, you can quickly separate items in a single cell into multiple cells. This method is handy when dealing with lists, addresses, or any data where items are grouped together.

Let’s dive into the steps to accomplish this.

Step 1: Select the Cells You Want to Split

Start by highlighting the cells that contain the data you want to separate. Click and drag your mouse over the relevant cells to select them.

Selecting the correct cells is essential to ensure that the data you wish to split is accurately targeted.

Make sure to include all the cells that need to be separated in your selection.

Step 2: Go to the Data Tab

split cells in excel shortcut

separate rows in excel