You will either have to fix the text file or the Excel worksheet after
importing the data...
Fixing Excel would be easier
Select the rows with missing information (Data | Filter)
Press F5 | Special | Visible Cells only
Right Click and insert cells (Shift cells right)... as per requirement
-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Pammy" wrote:

I have a txt file of stolen guns, the problem, some have a mak and type field
and some do not so data is not lining up correctly on the ones missing the
fields. What do you do about missing fields in the data? Using 2003 Excel