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:
- 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.
Notes:
- Splitting data into multiple columns is also available for Excel in Microsoft 365. Similarly, click the Data tab → select the Split Text to Columns button → select the Delimiter → click the Apply button.
- Analogical functionality is available in Google Sheets. Click on the Data → select the Split text to columns from the dropdown → select the Delimiter or allow for auto-detection → click on the delimiter selection pop-up.