Merge Assistant

A data related add-in product for Microsoft Excel

Do you have these problems:

• Need to combine entries in multiple cells into one cell?
• Want the ability to customize all of the merge options?

The Merge Assistant can solve all of these problems and more!

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 or one row wide. This identifies both the first cell in each row (or column) to be merged and the rows (columns) to be merged.
• The next dialog asks for the additional columns (or rows) to be included. You can select multiple columns (or rows) at one time and click on the Add button.
• The third dialog that appears asks for merge options. You can merge based on cell appearance or cell value.  Merging on cell appearance allows one to merge cells that have been formatted with leading zeros and to retain the leading zeros..
• The last dialog gives you the concatenation options:

When you click OK on the above dialog the cells are merged.