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:
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.
