one way is after the import to select the names choose copy
click in cell A2
edit / paste special and tick the transpose check box
you can then delete row 1

Cheers
JulieD

"Burger23" wrote in message
...
I have a list of names, separated by a comma, in a file named file.txt.
When
I use Excel to open this file, I get the Wizard to format-- but the names
are
all listed in a single row (1) and many columns. I can not determine how
to
format to lisst all names in a single column with name rows. Thanks..