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