To split data in a column based on a delimiter --
- Select the column you're interested in splitting
- Select the DATA tab on the top ribbon
- Navigate to the Text to Columns button in the DATA TOOLS menu.
- Once the wizard opens, specify whether the data is delimited (character separator) or has a fixed width (space separator). For this workshop, we will be working with delimited data.
![](https://libapps.s3.amazonaws.com/accounts/322203/images/column2.PNG)
- After selecting delimited, you will be asked to specify the character used as a delimiter.
![](https://libapps.s3.amazonaws.com/accounts/322203/images/colum1.PNG)
- The next window will ask you to specify which of the split columns to keep and to specify the data type.
![](https://libapps.s3.amazonaws.com/accounts/322203/images/colummm.png)