Merge cells in Microsoft Excel - Combine columns, rows in Excel workbooks

 

Merge Cells Wizard for Microsoft® Excel®

Merge Cells Wizard for Microsoft Excel - merging columns, rows, values, data and text

For Microsoft Excel 2010 32-bit and 64-bit, Excel 2007, Excel 2003.

Merge Cells Wizard is an add-in for Microsoft Excel that efficiently merges data from several cells into one. Do you need to combine values from multiple cells? Or, do you want to merge entire rows, columns or a range of cells retaining all their values? If you have the Merge Cells Wizard add-in at hand, the task will take you just a few seconds.

This smart plug-in will save hours of your time. A couple of clicks and you have data from several Excel cells joined into one cell, or entire Excel rows and columns merged exactly as you need them. The Merge Cells Wizard combines various types of data such as numbers, dates, special symbols or text. You can separate the merged values with any character, including the line break / carriage return.

Download NowFeature TourSee how it works

Keep all data if the selection contains multiple values

Using Merge Cells Wizard you will never see the "The selection contains multiple data values" message

One more fascinating feature of the Merge Cells Wizard is that it keeps all data when the selection contains multiple data values. If you try to merge data from several cells into one cell using the standard Microsoft Excel option, you will get the following error message: "The selection contains multiple data values. Merging into one cell will keep the upper-left most data only."

With Merge Cells Wizard you will never see this message again. The Merge Cells Wizard add-in preserves all data if the selection contains multiple data values. Your data in Microsoft Excel will never be lost!

Need to merge 2 Excel tables?

If you want to merge data from two Excel spreadsheets, check out Merge Tables Wizard. With this add-in you can merge 2 different worksheets in just 1 minute.

How to merge columns in Microsoft Excel: 3 easy steps

Imagine that you have a list of your clients' addresses split into three columns: Address, City and ZIP code. You want to have the clients' addresses in one cell separated with a comma and a line break.

Select the cells you want to merge and click the Merge Cells Wizard icon

1. In your worksheet, select the cells you want to combine and click the Merge Cells Wizard icon.


2. In the Merge Cells Wizard dialog box, set the parameters as follows:

In the Merge Cells Wizard dialog box, configure the settings.
  • "Merge selected cells" field: row by row.
  • "Separate values with" field: select "Other" option, then enter a comma and press Alt+Enter in the edit box.
  • "Place the results to" field: select left cell.
  • Check the "Clear the content of selected cells" checkbox.
  • Check the "Skip empty cells" checkbox.
  • Check the "Wrap text" checkbox.
  • Click the "Merge" button.
Addresses are merged into one cell separated with a comma and a line break

3. That's all, now you have the addresses in one cell separated with a comma and a line break.


With Merge Cells Wizard for Microsoft Excel you can:

  • Join Microsoft Excel cells row by row using any separator and place the results to:
    • Left cell of each row
    • Right cell of each row
    More about merging cells row by row

  • Merge multiple cells into one cell using any separator and place the results to:
    • Top left / right corner of the selected range
    • Bottom left / right corner of the selected range
    More about joining multiple cells to one cell

  • Combine selected Microsoft Excel cells column by column and place the results to:
    • Top cell of each column
    • Bottom cell of each column
    More about combining cells column by column

  • Merge multiple ranges (even non-adjacent ones) and place the results into the selected cell.
  • Clear the cells after their content has been merged.
  • Combine all areas in the selection.
  • Exclude empty cells from merging.
  • Wrap text in the resulting cells.

Merge Cells Wizard for Excel is compatible with

  • Operating System: Microsoft Windows 7 (x86, x64), Windows Server 2008, Windows Vista (x86, x64),
    Windows 2003, Windows XP.
    .NET Framework 2.0 must be installed.
    If you need to install the add-in for a group of users, please see Corporate deployment.
  • Microsoft Office Excel 2010 32-bit and 64-bit, Excel 2007, Excel 2003.

Download now and see how it can help you




Microsoft Office Marketplace logo

Order Now


Join us on Facebook

Click Like and get 15% discount on all our products right now!


Excel Add-ins Collection - quick way to increase your effectiveness in Excel

Merge Cells Wizard for Excel




 

Ordering information


You can purchase a license of Merge Cells Wizard for Excel online with any major credit cards, bank wire transfer, check, PayPal or order by fax.

You can buy this add-in as part of the AbleBits Add-in Collection for Excel (11 add-ins in 1 package) and save 60% off.

Merge Cells Wizard for Excel pricing, per license

Quantity

USD

EUR

GBP

Volume discount

1

29.95

19.95

19.95

2-4

28.45

18.95

18.95

5%

5-9

26.95

17.96

17.96

10%

10-24

23.95

15.96

15.96

20%

25-49

20.95

13.97

13.97

30%

50 & more

Contact us for a special price

Buy Now

Have a question? Feel free to ask

Your Name*

Your e-mail*

Subject

Message*

Please remember that we work from 9am to 6pm GMT this is 5:00am - 2:00pm EST, 2:00am - 11:00am PST and our public holidays may differ from yours.




Links   |   Sitemap   |   About us




Plug-ins for Microsoft Excel and Outlook

Copyright © 2003 - 2012 Add-in Express Ltd. All rights reserved.

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.