Import DataHi

When I for instance import txt files containing 4 criteria (Name, Business
Unit, Allocation Code & Dept) into Excel using Data - Import external Data
- Import Data, the text import wizard appears. I choose delimited and when I
go to step 2 of 3 I use space delimiters. What happens next is that the data
does not always get into the right column.

Column A Column B Column C Column D Column E
John New York 13 Sales
Mike LA 25 Accounting
Jesse New York 14 Sales-Exec
Donna New York 98 Finance

How Do i get Excel to import data in the correct columns (i.e. Name by name,
BU by BU, AC by AC and Dept. by Dept.)?!

Many tthanks in advance!!!