Splitting a fixed-width column

  1. Right-click the column header and select Split Column by Fixed Width.
  2. Two ways exist to specify the column width. In the table, specify the starting position and the length of the string. In the box, highlight the desired string and specify a number.
  3. Click OK to save the changes and close the dialog box.