How to split data into two columns in Excel
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.
- For more information on splitting data in excel see here.