How to Split Excel Data Into Two Columns

Prepare Your Columns
1. Open the Excel file with data that you want to split.
2. Insert a blank column to the right of the column with data you want to split. For example, if the column you want to split is column F and data exist in column G that you do not want overwritten, insert a new column between columns F and G. To insert a column, click any cell in the column to the right of your data column.
3. Click the 'Home' tab on the ribbon.
4. Click the 'Insert' button in the Cells group.
5. Select 'Insert Sheet Columns' to create a blank column to the left of your cursor, that is, to the right of your data column. For example, if your data reside in column F, you would click on any cell in column G before inserting the column. Excel creates a new column to the left of column G.
Split Your Column
6. Click the 'Data' tab in the ribbon.
7. Select the column you want to split by highlighting the column. To highlight the column, click on the column letter.
8. Click the 'Data' tab on the ribbon. Click 'Text to Columns.' You will see a wizard pop up that will guide you through the process.
9. Select either 'Delimited' or 'Fixed Width,' and click 'Next.'
10. Select the kind of delimiters you want if you selected 'Delimited' in the previous screen. The most common delimiter is a space. Select as many delimiters as apply. Excel will use this information to determine where one piece of data ends and another begins so it can split the data appropriately. If you selected 'Fixed Width,' you will see a ruler above your data. Click on the ruler at the desired points to create a break.
11. Click 'Next.' You will see the third step in the process.
12. Select a format for each of your two columns if you want. However, this is not necessary, and you can always adjust the formats later. Excel will assign the General format for each column as the default.
13. Click 'Finish.'