The best bet is to get whatever application is producing the text file to
include suitable delimiters, perhaps tab or comma. Space is obviously not
suitable when you have spaces within fields.
--
David Biddulph

"Basta1980" wrote in message
...
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!!!