Thread
:
how do I import .txt file as rows not columns?
View Single Post
#
1
Posted to microsoft.public.excel.misc
Phil Zack
external usenet poster
Posts: 1
how do I import .txt file as rows not columns?
I have a text file of several hundred email addresses, which I want to import
into Excel (or Access). The data look like:
;
;
... etc
but when I use the Import External Data wizard, it imports the whole lot as
columns in the first row, and cuts off the last few hundred, as there are
more than 255 records, so what I get looks like:
A / B /
C /
1/
/
/
How can I import them as single column entries in many rows? What I want is
this:
A /
1/
/
2/
/
3/
/
Thanks in anticipation,
Phil
Reply With Quote
Phil Zack
View Public Profile
Find all posts by Phil Zack