You use the Split Field dialog box to divide the contents of a field into two fields.
The Field box displays the name of the selected field.
In the “Number of characters in a column” box, you enter the number of characters to place in the first field. For example, if the selected field contains UPC100–10–1, enter 3 to place UPC in the left field and 100–10–1 in the right field.