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.

Jagiellon Wilson wrote:

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

--

Dave Peterson

Thanks! It worked great!

Jag

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
--
Is this doable? Thanks,
xw


"Dave Peterson" wrote:

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.

Jagiellon Wilson wrote:

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

--

Dave Peterson