import text and sort data into excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Select Column A, then
Data->Text to Columns
Regards,
Stefi


„Boozman†ezt írta:
 
Back
Top