Re: import text and sort data into excel

Tech-Archive recommends: Fix windows errors by optimizing your registry

One way ..

Assume data is in col A, in A1 down,
in groups of 5 lines each, w/o any blank lines in between, viz.:

Nam1 < 1st group
Add1
Cit1
State1
Tel1
Nam2 < 2nd group
Add2
Cit2
State2
Tel2
etc

Put in B1:
=INDEX($A:$A,ROWS($A$1:A1)*5-5+COLUMNS($A$1:A1),)

Copy B1 across 5 cols to E1, fill down until zeros appear
signalling exhaustion of data from col A

You'd get the layout:

Nam1 Add1 Cit1 State1 Tel1
Nam2 Add2 Cit2 State2 Tel2
etc

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Boozman" <Boozman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:45439A82-76CA-4BD2-A56E-43522E31E741@xxxxxxxxxxxxxxxx
> I am trying to take a txt file and is able to import it but then the info
is
> in 1 column underneath each other but i want to divide it into 5 different
> columns.The info is large over 800 companies divided by
> name,adress,city,state and telephone number.I want to divide that info
into 5
> respective columns.I have tried and concateante and then divide it without
> success.
>
> Help will be greatly appreciated
>


.