How do I import data into a column?

B

Burger23

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..
 
J

JulieD

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
 
M

Marc Fleury

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..
Click to expand...

Don't know if there's an easy way to do this in Excel, but I'd use a word
processor to find and replace (replace commas with carriage returns)
 
B

Burger23

Thanks so much, Julie--that did it. Onward.....

JulieD said:
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
Click to expand...
 
B

Burger23

Tried this in Word-- but how do you enter a carriage return- pressing Enter
does not do the trick for me

Thanks
 
J

JulieD

Hi

in the edit / replace dialog in Word
click in the replace with box
click on the more button
click in the replace with box again
click on the special button
choose paragraph mark

alternatively just type
^p
in the replace with box (all in lower case)

Cheers
JulieD
 
B

Burger23

I sucessfully coverted the document in Word, but Excel does not seem to know
what to do with the paragraph symbols. Ideas please
 
J

JulieD

Hi

if you select and copy the document in word (control & A then control & C)
then click in cell A1 of a worksheet in excel and paste (control & V)
does it work like you want.

if not, you could do this
control & A in word to select all
click on the insert table icon on the toolbar your list should be turned
into a table
now copy the table and paste into excel.

Cheers
JulieD

Burger23 said:
I sucessfully coverted the document in Word, but Excel does not seem to
know
what to do with the paragraph symbols. Ideas please
Click to expand...
 
Top