Using the import text wizard select fixed width instead of space delimited,
then adjust the column breaks in the next screen by either dragging the
column break indicator left or right, or clicking on the ruler bar at a
specified location to insert a column break. To remove unnecessary column
break lines just double click on them.
--
Kevin Backmann


"Basta1980" wrote:

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!!!