Importing Single-Character Delimited File in Microsoft Excel 365

 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".

Step 2

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

Step 3

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

Step 4

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

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.

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.

Step 7

The formatted data will be presented like the picture below.