Combine cells, rows, and columns in Excel

Merge Cells Wizard for Microsoft Excel

Task

You have 10 minutes to combine data from several cells into one but when you use the standard Microsoft Excel option, you get the error message: "The selection contains multiple data values. Merging into one cell will keep the upper-left most data only."

Solution

Merge Cells Wizard for Microsoft Excel presents extended merging functions such as combining values by row, by column or into one cell. Besides, you can pick a separator and some additional options like combining all areas you select or removing values from the chosen cells after merging.

Merge cells in Excel by row, column or all into one keeping all data.

Merge Cells for Excel key features

Select the cells to merge, define the settings and enjoy the quick results!
  • Combine Excel data row by row, column by column or into one cell.
  • Select a standard separator or enter your own.
  • Define where to place the merged results.
  • Remove values from the selected cells after merging.
  • Merge all areas in the selection.
  • Skip empty cells from merging.
  • Wrap text in the merged cells.
  • Back up the original worksheet.

Tip

You can get this add-in as a part of Ultimate Suite for Excel - 20+ add-ins destined to cut your time and clicks on the most frequent spreadsheet tasks.

How Merge Cells Wizard works

Merge Excel columns: choose the delimiter you want and have a backup copy of your table.
Merge your Excel data by row.

Whether you need to combine data in cells, rows, or columns, Merge Cells Wizard for Microsoft Excel is the add-in to help you.

The intuitive wizard displays all available merging options for you. All you need is to select the range or ranges with the values to be combined and the plug-in will neatly join cells, rows, or columns with data.

You can use one of the pre-defined separators or enter your own, clear the cells after merging or join all areas in the selection, skip empty cells, apply text wrapping or automatically save the original copy of your spreadsheet before merging.

Merge data row by row, column by column or into one cell

With Marge Cells Wizard you can combine data exactly as you need it: by row, column or into one cell. Now it takes about 5 clicks to merge parts of names, addresses, or create labels for printing.

Select any separator or enter your own

When you join cells, you can specify the boundary between values by using a separator. It can be one of the common delimiters like line break, comma, space, or semi colon. You can really enter any character or a combination of characters in the Other field.

Define where to place merged results

The enhanced functionality of the add-in enables you to select the destination cell where the results will be moved. While merging rows, you can place them to the left or right cell of each row. When you combine columns, you can choose between placing outcome to the top or the bottom cell of each column. If you join into one cell, it is possible to pick the top left/right or the bottom left/right cell of the range.

Remove values from selected cells after merging

With this merging tool for Excel and its Clear the contents of selected cells option, you can delete values from the cells you pick for the merge.

Merge areas in the selection

If you need to merge all cells in your Excel worksheet by row, column or into one cell, you just tick the Merge all areas in the selection checkbox. It can be useful if you want to avoid empty ranges in your table.

Back up the original worksheet

With this handy tool and the possibility to create a backup copy of the current table, you will regain the original data any time you need them again. This smart feature lets you choose the best merging option without closing the file or losing your data.

29.95
Buy now

Merge Cells Wizard for Microsoft Excel system requirements

Operating System

  • Windows 8 (32 and 64-bit)
  • Windows 7 (32 and 64-bit)
  • Windows Vista (32 and 64-bit)
  • Windows XP (32-bit)
  • Windows Server 2003, 2008, 2012
  • .NET Framework must be installed.

Microsoft Excel

  • Microsoft Excel 2013 (32 and 64-bit)
  • Microsoft Excel 2010 (32 and 64-bit)
  • Microsoft Excel 2007
  • Microsoft Excel 2003

Merge Cells Wizard for Excel version

Current add-in version: 4.0
published on: Jan 15, 2013

Order Merge Cells Wizard for Excel

29.95
Buy now
 
Contact us