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.
- After selecting delimited, you will be asked to specify the character used as a delimiter.
- The next window will ask you to specify which of the split columns to keep and to specify the data type.