In column A you have:

name
street
city
state
zip


in cell b1 enter =a2
c1 =a3
d1 =a4
e1 =a5

select b1:e5
fill down
select columns b:e
copy
paste special values
sort by any column other than A
delete rows where b:e are blank

--Carlos

"CPOWEREQUIP" wrote in message
...
Hi. I have just pasted an address list from Word to Excel. I want to
change
the multi line entries to single line entries so I can merge it with
another
document in Excel.

I hope this makes sense.