Page Comparison

 Should you have any questions or concerns with the instructions, please notify the Technology Service Center for assistance. 

Step 1

In Excel, on the "Data" menu, select "Get Data".

Image RemovedImage Added

Step 2

Select "Legacy Wizards". Then, select "From Text (Legacy)".

Image RemovedImage Added

Step 3

Select the file to be imported. Click "Import".

Image RemovedImage Added

Step 4

Step 1 of the "Text Import Wizard" is presented. Select "Delimited" for the file type, click the "Next" button.

Image RemovedImage Added

Step 5

Step 2 of the "Text Import Wizard" is presented. As seen above, your file is an asterisk delimited file. Under "Delimiters", check "Other" box and enter * (an asterisk) in the box to the right, as shown below. Click the "Next" button.

Image RemovedImage Added

Step 6

Step 3 of the "Text Import Wizard" is presented. You may wish to change the data format to "Text", particular for columns with numeric data (to keep leading zeroes from being omitted and/or to avoid losing two zeroes after a decimal point).

Check to see if the vertical lines (data separators) are in the correct places. Make adjustments, moving them to the left or right, if necessary. Click the "Finish" button.

Image RemovedImage Added

Step 7

The formatted data will be presented like the picture below.

Image RemovedImage Added