Import Text

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

Guest

I want to import a text files into Excel and have very other line in a
different column

Like this, the original plain text file (txt):
A
B
C
D

Excel:
A | B
C | D

Is this doable in Excel?

Thanks
 
After you import the data, put this in B1:
=INDEX(A:A,(ROW()*2-1))

Put this in C1:
=INDEX(A:A,(ROW())*2)

Select B1:C1 and drag down (about halfway)

Then select columns B:C and edit|copy, edit|paste special|values

And delete column A.
 
I have a similar but more complicated situation. I want to import data in a
text file to a Excel file.
Text:
A = a
B = b
C = c

A = a1
C = c1
....
Excel:
A B C
a b c
a1 c1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing data from Excel worksheet into Excel template 2
Exchanging data 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Import txt files into Excel 7
Import data row->column 2
Drag text file to Excel -- stopped working 5
Why this paste result? 4
Split column contents (de-concantenate) 7

Back
Top