Need help!!!

[roger_home]

I have 6600 entries that I need to fix. They are set up as follows:
a1...name b1...address c1...phone b2...city, state, zip
then there is a blank row, then the next person is listed.
I know how to add a new column to move c1 info to d1, and manually mov
b2 info up to c1, but that will take forever. Can someone give me th
formula to do it quickly (and to delete the info in b2)? I want to us
mail merge in WORD when I'm done, just so you know. I'm also limited i
my EXCEL knowledge so please break it down for me so I can understand.
would be SO grateful for any help.

Thanks
roger_hom

 

[Paul B]

Roger, see your post in Excel.misc

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2003