Splitting a column by delimiter

  1. Right-click the column header and select Split Column by Delimiter.
  2. In the Delimiter box, select the delimiter character used in the source file. Choose from Comma, Hyphen, Pipe ( | ), or Tab. The default is Comma. The Preview box automatically updates to show the result of your selection.
  3. Click OK.