I have Office for my mac, I use Word all the time, but suck at using Excel. I am trying to help a friend out with a task. He needs me to clean up an excel doc of his customer list. He exported it from Quickbooks. Its all messed up, and I got it cleaned up, but its still messed up, and the list is 3000+ customers long. I need only three columns, A for full name, B for street address, and C for city state and zip. Problem is, for some reason, I have a fourth column, D, and it has some of the info that should be in C (mainly the zip). First thing I need, is to find out how to merge columns C and D into one and make it the new C column, is this possible? Also, is there a way to auto capitalize text and add spaces to when there isnt one (for instance, lots of the addresses dont have a space after the comma in the address). Trying to do this the easiest way, its so much info. Any help would be appreciated.