I'm trying to figure out how to combine a number of columns of data to
format First & Last names for a mailing list. The problem is each
record/row can contain different infomation depending on the source. Here's
an illustration:

Col A Col B ColC ColD ColE
Bob & Mary A Jones
Bill
Williams
Pete R & Sue Smith
etc

When done I would like:

Col A Col B ColC ColD ColE
Bob & Mary Jones
Bill
Williams
Pete & Sue
Smith

Here's a linl to a jpeg of the colunms in my Excell file...is there any way
to write a formula that would accomplish the above...even a set of forulas
to run would be great...ususally have about 3000 records to due and going
line by line is nuts !?

http://scottsdalearizona-homesforsal...ages/excel.jpg

Thanks, Tim