With Ablebits.com Merge Cells Wizard you can merge data from several Excel cells into one cell using any separator you like.

Use Merge Cells Wizard every time you need to place values from several Excel cells to one cell, to merge row by row, column by column. If the selection contains multiple data values, Merge Cells Wizard will help you avoid loosing data in Microsoft Excel. Whole columns and rows can be merged with a click.

With Merge Cells Wizard for Microsoft Excel you also can:

– Separate data with any separator you like (e.g. line break)

– Merge multiple ranges (even non adjacent) and place the results to the selected cell.

– Clear the cells whose values have been merged.

– Merge all areas in the selection.

The Merge Cells Wizard works with Microsoft Excel 2010 32-bit and 64-bit, 2013, 2007, 2003.