Free download
365 2021 2019 2016Download this and 70+ other tools for Excel included in Ablebits Ultimate Suite
14-day fully functional version
14-day fully functional version
Merge cells in Excel the way you need them
Combine cells, rows, and columns without losing data
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.
With Merge Cells you will
- Combine multiple cells into one cell Join multiple Excel cells and place your result either to the top left/right cell, or to the bottom left/right cell.
- Merge columns row by row Combine columns and save the result to the left or to the right column.
- Keep all your values while merging cells The add-in won't delete your data, even if the selection contains multiple data values.
- Combine rows column by column Merge several rows and place the result to the top or to the bottom row.
- Separate your merged values Set a separator for your merged values: comma, semicolon, space, line break, or any character of your choice.
- Merge and aggregate cell values If you've got numerical data, you can not only combine values but also apply aggregate Excel functions.
How to combine columns in Excel
Combine columns into one
The columns are merged, the values are separated by the chosen delimiters
Merge rows into one
The values from the selected rows are merged
Merge cells in Excel into one
The values are merged and separated by the chosen delimiters
Merge columns, rows, or cells into one and aggregate values
Combine cells with aggregate Excel functions
Merge columns, combine cells, join rows
A quick and easy way to do it all at once
Combine columns, rows, and cells
and preserve all your values
and preserve all your values
Separate the values with
semicolon, comma, space, line break,
or any character of your choice
semicolon, comma, space, line break,
or any character of your choice
Merge all areas
in the selection in one step
in the selection in one step
Over 150,000 happy users!
Only true Ablebits reviews from our customers
I can't tell you how happy I am with Ablebits
I can't tell you how happy I am with Ablebits and the time it has saved me over the years. I started using Ablebits with my previous employer, probably 15 years ago and I constantly recommend your products to coworkers. You truly have top-notch customer service. Keep up the great work!
Jeff Meyer
Love the products!
Love the products! They have saved me thousands of hours and they are responsible for me getting a promotion at my last job, which helped me land my current position as a manager.
David Johnston
It's the best $100 we've ever spent!
I talked my supervisor into getting Ultimate Suite. I often deal with huge tables and matching between versions has always been a nightmare. He asked me about the new tools and I said: "It's the best $100 we've ever spent!" Indeed has saved me hours of work time. So, one big "Thanks!"
Mike Cavanagh
Incredible product, even better tech support…AbleBits totally delivers!
I use AbleBits every day and keep finding new uses. Changing jobs, I get my new employer to cough up the very reasonable cost of this software. There're things I just can't complete any other way in large datasets. My coworkers think I'm a wizard. But I'm just a religious user of AbleBits.
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier by Ablebits
I've been using Ultimate Suite for almost a year and found it invaluable for my projects. I like the ability to merge tables based on 1 or more attributes, transpose columns and rows, and to transform data with Cell Cleaner utility. Plus, Ablebits' support is reliably fast and courteous.
Jackie Lee
Excel is at its best now
Ever since I found your add-ons, it has been a life saver or should I say a major time saver. I have bought two packages for both work computers. Excel is at its best now because of you. Thank you!
Annie C.
KUDOS to you guys for solving a problem that our IT department doesn't understand
Our IT thought they know how the sales department should function and destroyed some data files. With AbleBits I was able to regenerate my database in a few clicks. This was AWESOME. KUDOS to you guys for solving a problem that even our IT department doesn't understand.
Erik Peterson
AbleBits suite has really helped me when I was in a crunch!
Having AbleBits suite really helped me when I was in a crunch! It was intuitive and saved time on my job! Now I'm finding other capabilities I wasn't aware of, (first needed the easy merge capability). The other features are valuable time savers as well. Thanks for the product!
Nelda Fink
Ablebits is a fantastic product - easy to use and so efficient.
Ablebits is a fantastic product that I also brag about, because it is easy to use and so efficient.
Debra Celmer
I have enjoyed every bit of it and time am using it
I got this add-in and it is doing a great job for me. I have enjoyed every bit of it and time am using it. Great one from AbleBits… I recommend this for any data management and excel users.
Christian Onyekachi Nwosu
I love the program, and I can't imagine using Excel without it!
Thank you for your commitment to Ultimate Suite. I love the program, and can't imagine using Excel without it! The program paid for itself the first day I used it. Your team has created a really great set of tools for use within Excel. Thank you, thank you, thank you!
Robert Madsen
One word… WOW!
One word… WOW! I recently bought the package of add-ins for Excel. I've used it ONCE and it has paid for itself. It literally saved me HOURS of work. KUDOS!
Dave Brown
I don't know how to thank you enough for your Excel add-ins
I don't know how to thank you enough. I stumbled upon your site figuring out how to merge 2 tables. When I saw a free trial, I thought how well is this going to work? I downloaded it and am AMAZED. I don't know how I lived without it. THANK YOU for making my life easier.
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Anybody who experiences it, is bound to love it! There're only 2 ways to "exploit" Excel's potential: be a geek or embrace Ultimate Suite. Why waste time on routines that can happen with a click of a mouse? Make use of Excel's capabilities without wasting time and energy.
Kumar Nepa
I love your product
I love your product. It really saves me a lot of time and makes my job much easier.
Brad Gibson
The best spent money on software I've ever spent!
I just have to tell you that I love your AbleBits Collection. I can't tell you how much time it has saved me, particularly Merge Tables Wizard, Duplicate Removers, Merge Cells Wizard, and Split Names. This was the best spent money on software I've ever spent!
Patrick Raugh
Awesome!!!
Awesome!!! I love the tools and have been using the compare one everyday since I downloaded it.
Sheila Blanchard
THANK YOU, THANK YOU, THANK YOU!!
I'm happy there is a company (Ablebits) where support really can solve customer's problem! Great job!
Tibor
It is like having an expert at my shoulder helping me…
I feel that Ablebits has people like me in mind with software development. It's like having an expert at my shoulder helping me work more efficiently. Now I have more time to goof off at work. Uh, that last statement isn't true - I just have a lot less stress as things go so much smoother.
Linda Shakespeare
Your software really helps make my job easier
Your software really helps make my job easier. I don't know what I would do without Duplicate Remover, I use it several times a day for every project I work on. Thanks for making my life easier.
Jeannie C.
Frequently asked questions
What is Merge Cells and what do I need it for?
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.
Doesn't Microsoft Excel do the same without any add-ins?
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.
How does Merge Cells work?
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.
Can I merge the values into one cell?
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.
How can I merge cells in Excel and keep all data?
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!
Can I merge cells if my selection includes several areas?
Sure! For this just tick off Merge all areas in the selection option.
My table has empty cells, can I avoid merging them?
Yes, to combine only cells with data, tick off Skip empty cells option.
I want my merged values to fit into the size of the cell. Is it possible?
Of course, just tick the checkbox Wrap text and the result will fit into the size of the chosen cell.
Choose your Ultimate Suite edition
Merge Cells + 70 other time-saving tools in one powerful suite
| 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. |
|||
Special offer
Enjoy Ultimate Suite
with up to 30% discount Offer ends August, 20th
|
$69 $99 Buy now |
$11995 $14995 Buy now |
$29996 $375 Buy now |
Supported versions
Microsoft Excel
- Excel included in Microsoft 365 (formerly Office 365)
- Excel 2021
- Excel 2020
- Excel 2019
- Excel 2016
- 32-bit and 64-bit
- Note! Office Insider is not supported
Windows
- Windows 11
- Windows 10
- Windows 8.1
- Windows 8
- Windows 7
- 32-bit and 64-bit
- Note! Windows Insider is not supported
- Note! Windows X (on ARM processors) is not supported
