Merge Assistant for Microsoft Excel

The Merge Assistant is an add-in for Microsoft Excel that will combine entries in multiple cells into one cell. It is entirely menu driven:

When you click on the Merge Assistant, a dialog appears that asks for a range of cells one column wide. This identifies both the first cell in each row to be merged, and the rows to be merged.

The next dialog asks for the additional columns to be included. You can select multiple columns at one time and click on the Add button.

The third dialog that appears asks for the destination. It can be on the same sheet as the cells to be merged, or it can be on a new worksheet or a new workbook.

The last dialog gives you the concatenation options. For example you can merge in "address format" where each entry is on a separate line when you printout the merged result. Or you can separate the entries with any characters you want. There is even an option to separate the first two entries with a comma and then use a space (Last name, First name middle initial style)