How to split data into two columns in Excel to prepare for OnePageCRM import

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

Open the spreadsheet containing the data that you want to separate → select the data by clicking on the column heading at the top.
Click the Data tab → select  Text to Columns button in the Data Tools section of the ribbon at the top of the window.
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. 
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.
Select the data format for you require →  Finish.
The data in the column you split will be moved to a new column on the right.

Still need help? Contact Us Contact Us