Import Text
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
|