Importing data from Word text file

[Matt]

I have a mailing list in a WORD text file that I went to import into an
Excell worksheet. I have 425 entries like this:

Name
Company
Street
City, State, Zip

When I use "Get Data" to important the list, I want each name/address
entry to go into one cell. Insteal, it puts each element into a
different cell. Which won't work in my label printing program. The
complete name/address entry needs to get one cell.

Any suggestions on how to do this? I can't find anything on MS's
support website that helps at all.

Thank you.

 

[Bernard Rey]

I have a mailing list in a WORD text file that I went to import into an
Excell worksheet. I have 425 entries like this:

Name
Company
Street
City, State, Zip

When I use "Get Data" to important the list, I want each name/address
entry to go into one cell. Insteal, it puts each element into a
different cell. Which won't work in my label printing program. The
complete name/address entry needs to get one cell.

From your description, I understand that you have:

A1: Name1
A2: Company1
A3: Street1
A4: City1, State1, Zip1
A5: (blank)
A6: Name2
A7: Company2
A8: Street2
A9 City2, State2, Zip2
Etc.

And you would like to have:

A1: Name1, Company1, Street1, City1, State1, Zip1
A2: Name2, Company2, Street2, City2, State2, Zip2

Is this right?

If it is, then you can type in the first cell of a blank column (let's say
col B):

B1: = A1 &", "& A2 &", "& A3 &", "& A4

Or you can also use:
=CONCATENATE(A1,", ",A2,", ",A3,", ",A4)
Which will display the same result...

Then select cells B1:B6 and copy the block down to the bottom of your list
(I guess it should be cell B2124).

Then copy the whole B2:B2124 range, and paste it in place with the "Paste
Special..." > "Values" item, delete col A and get rid of the blank rows
(using "Data" > "Sort")...

If this doesn't match your requirements, could you describe more precisely
why it doesn't?