How to split data into two columns in Excel

If you wish to separate data from one column into two follow the instructions below: 

1
Open the spreadsheet containing the data that you want to separate → select the data by clicking on the column heading at the top.
2
Click the Data tab → select  Text to Columns button in the Data Tools section of the ribbon at the top of the window.
3
Select a file type option:
  • Delimited: if data contains some specific characters by which it can be separated such as empty space, dash etc
  • Fixed width: if you want to split the data at a set number of characters. 
4
Next.
5
If you selected Delimited choose the character that you want to set as the split →  Next
If you are using the Fixed width option →  click  the point where you want the split to occur → Next.
6
Select the data format for you require →  Finish.
6
The data in the column you split will be moved to a new column on the right.
NOTES
  • For more information on splitting data in excel see here.

Still need help? Contact Us Contact Us