Deleting a split

Right-click the column header and select Delete Split. All the data is consolidated back into one column.

If the data is split by fixed width with three or more splits, you can remove a specific split through the By Fixed Width dialog box.

To delete a specific split:

  1. Right-click the column header and select Edit Split.
  2. In the table, delete the starting position and length values for the split to be removed.
  3. Click OK.