If you need to combine several cells into one, merge columns row-by-row or rows column-by-column, Merge Cells for Excel is the best assistant for you. Just choose a range, select what to merge, pick a delimiter to separate values, click the Merge button - your cells are combined in a second with no values lost.
Merge Cells is an add-in for Microsoft Excel, which combines values in columns, cells and rows. If you need to get one cell out of several ones, merge columns row by row or rows column by column, Merge Cells utility is the best assistant of you.
No, it doesn't. If you merge cells with the help of the build-in Excel button, you will keep only the upper-left value, other values will be removed. Merge Cells saves all your data and allows to decide, whether to combine values into one selected cell or merge all areas in the selection.
You start the add-in, select your range and choose what to merge: columns, cells, or rows. Then you indicate a separator for the combined values, it can be space, comma, semicolon, line break, or any separator of your choice. You determine the place where to put the result. You can also choose to clear the contents of the selected cells, merge all areas in the selection, skip empty cells, and wrap text. Then you click Merge and the result is ready in a few seconds.
Find a more detailed description here.
Yes, this is what the add-in does by default. If you do not tick the checkbox Merge all areas in the selection, you will have your values combined into one chosen cell.
Merge Cells tool keeps all data when the selection contains multiple data values. With Merge Cells you will never see the message "The selection contains multiple data values. Merging into one cell will keep the upper-left data only" again. Your data in Microsoft Excel will never be lost!
Sure! For this just tick off Merge all areas in the selection option.
Yes, to combine only cells with data, tick off Skip empty cells option.
Of course, just tick the checkbox Wrap text and the result will fit into the size of the chosen cell.
Personal | Business | Business, 5 seats | |
One-time purchase You pay only once and can use the purchased version as long as you need. |
|||
Unconditional 60-day money back guarantee If you are not 100% happy with the product, you can cancel an order and get your money back with no questions asked. |
|||
Volume discounts
|
|||
Support for Excel 2019 – 2010 All Excel versions 2019–2010 are supported, both 32- and 64-bit. Also, all desktop Excel versions included in Office 365 subscriptions. |
|||
Free upgrades for 2 years During 2 years after the purchase you get all minor updates and major upgrades for free. |
|||
License for | Single user | Single user | 5 users |
Technical support service Our support team is always happy to help you via email, live chat, or phone no matter how long ago you purchased your license. |
|||
Corporate deployment (GPO, SCCM) Your system administrator can quickly and easily deploy Ultimate Suite for a group of users without even disturbing them. |
|||
Features and hotfixes on request We’ll do everything in our power to create additional features you need and fix the found bugs as soon as possible. |
|||
Spring Offer
Enjoy Ultimate Suite with 30% discount
Offer ends March, 15th
|
$69 $99 Buy now |
$99 $14995 Buy now |
$24757 $375 Buy now |