import external data
 

I try to import an email address list of 500 which I have in deliminated
text. I do all the steps in the Text Import Wizard but when I get to the
point to import, I can only import into row 1 horizontal, each email in one
column which doesn't work since there are too many email addresses to fit.
I can't figure out how I can import the email addresses into Column A
vertical down, row 1 -500. There is no option to choose.

Thanks for your help. Gary

import external data
 

More info../..
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Swan0tree" wrote in message
...
I try to import an email address list of 500 which I have in deliminated
text. I do all the steps in the Text Import Wizard but when I get to the
point to import, I can only import into row 1 horizontal, each email in
one
column which doesn't work since there are too many email addresses to fit.
I can't figure out how I can import the email addresses into Column A
vertical down, row 1 -500. There is no option to choose.

Thanks for your help. Gary

import external data
 

When you've imported into a row, you can transpose into a column.
You may, however, be better changing your input text file. Perhaps change
your delimiter from comma or tab to a new line or paragraph character, then
when you import it will put each in a new row.
--
David Biddulph

"Swan0tree" wrote in message
...
I try to import an email address list of 500 which I have in deliminated
text. I do all the steps in the Text Import Wizard but when I get to the
point to import, I can only import into row 1 horizontal, each email in
one
column which doesn't work since there are too many email addresses to fit.
I can't figure out how I can import the email addresses into Column A
vertical down, row 1 -500. There is no option to choose.

Thanks for your help. Gary