Merge Cells is an add-in for Microsoft Excel that combines multiple text cells. Use it to join values from several cells to one and merge several cells, rows, or columns keeping all data.
After you select the range, you'll have to pick one of the merging options for the cells. Please see below the examples of how each of them works.
Run the add-in by clicking on its icon in the Merge group on the Ablebits Data tab:
The add-in's window lets you adjust the following options:
Click the Merge button to combine values from the selected columns in Excel.
If you've got numerical data, you can not only combine values but also apply aggregate Excel functions. For this, select the function of interest in the Combine with drop-down list:
What if I have hundred of rows then wanted to Merge each two together ?
Thank you for your message. For us to be able to help you better, please email us at firstname.lastname@example.org with a small sample workbook containing an example of your source data and an example of the result you would like to get. Please shorten your tables to 10-20 rows. If you have confidential information in your records, you can replace it with some irrelevant data, just keep the format.
The result sheet is of great importance and often gives us a better understanding of your task rather than any text description. Please don't forget to include it. We'll look into your task and see if our software can help.
Can I create a shortcut to do this faster?
Unfortunately, it is not possible to create a shortcut for the add-in.
Hello - I am trying to mass merge cells together in column C based on unique date in column B. Is this possible?
For example: I want to merge all the dates into one cell based on the duplicate data in column to the right. Is this possible?
7/8/2019 Amos Brady-Harris
3/5/2020 Ann Taylor-McClintock
12/6/2019 Anne E.-Ekberg
2/5/2020 Anne E.-Ekberg
3/20/2020 Anne E.-Ekberg
Thank you for your interest in our software. It looks like our other tool, Merge Duplicates Wizard, can help you with your task. It combines duplicate rows into one by a key column(s). Please see the manual here.
Hope it will work for you.
Hi, thanks for this excellent tool. Is there any shortcut key available for Merge Cell (Merge Row into one) ?
Thank you for your question. Sorry, there is no shortcut key for the add-in.
I just started using Ablebits today so I am not familiar with the setup or some of the functions. Is there an undo function? I cannot find any icon for undoing a merge. Also, not all functions appear on the toolbar. How can I get them to appear? Finally, I merged several cells and not all of the data remained in the new cell. What happened.
Thank you for choosing our product.
Unfortunately, Excel doesn't allow us to support full-featured Undo, that's why we create backup copies of worksheets. If you tick off Create a backup copy of the worksheet in the add-in window, a copy of your table containing the original data will be created in the same workbook after using the tool. The backup sheet has the same name, but with the # sign at the beginning and the number of the backup copy at the end.
As for the missing functions on the toolbar, which ones do you mean? Please clarify.
If you get the incorrect result after merging the cells, please describe your task in detail and send us a sample workbook with your data and a screenshot of the add-in with the selected options to email@example.com. We'll try to reproduce the issue on our side and find out what may be wrong.
Thank you for your time.
When will the next version of AbleBits come out? I need the formatting to be preserved.
Thank you for replying. I'm sorry, but our add-in doesn't preserve the formatting of the merged cells and this functionality is unlikely to be available in the upcoming updates.
I am considering purchasing this product and I installed the trial version. However, I could not find a solution to my issue. Please let me know if this can help. My problem is as follows:
I have an excel file with 1 column 20000 rows. I need to concatenate the content of every 50 cells so that in the end I have text in only 400 cells (each of these cells contain the text of 50 original cells).
Could you help?
Forgot to mention: I don't want to do it 400 times! :)
Thank you for your comments, Cristina.
We have just replied to you via email, please check your Spam/Junk/Trash email folders if you still don’t see our email in your Inbox. Thank you.
The merge tool does not preserve text formatting. I'm merging sells with mixed bold and italic text, and the result is all text is converted to the formatting of the first word. How can I preserve the existing formatting?
Thank you for your comment.
I'm sorry but the current version of our Merge Cells tool doesn't preserve the formatting of each and every cell. Only the formatting of the cell where you place all the records into is applied to all the values once the range is merged.
If I am trying to merge two cells together, but I would like to keep the formatting of both the original cells how would I do that?
For instance A1 is normal font, A2 is Bold, and I would like them to stay this way when I combine them together.
Thank you for your comment.
I'm sorry, but our add-in doesn't preserve the formatting of the merged cells.
Please tell me the Shortcut key of Merge Cells
Hello Ashok Verma,
Thank you for contacting us. I'm afraid Merge Cells does not have a shortcut key. However, you can add the utility to your Quick Access Toolbar by following these instructions.
How to merge cells without a space or character in between?
Thank you for the comment.
To merge the values without any characters between them, simply leave the Separate values with filed empty. Use the Delete button on your keyboard to remove the symbols the tool offers and click the Merge button on the add-in pane.
Please feel free to contact us again with any other issues.
Today we purchased your product. We want to merge four columnbs into one. However, We we try it says " This operation cannot be applied to the selected range". It only allows us to do 3 or 4 column merges at a time. We have 20,000 plus rows. Please advise.
Thank you for choosing our product. I am sorry about the problems you experience with it.
Please contact us at firstname.lastname@example.org and attach a screenshot of the add-in window when you use it (for us to see the options you check), a screenshot of the error message, and, if possible, the Excel books you use. We will try to reproduce the issue and search for the ways to fix it asap.
Where is the backup copy stored? I can't find it.
Thank you for contacting us.
If you tick the Backup this worksheet option, the tool will create a backup sheet in the same workbook where you merge cells. The backup sheet will have the same name as your sheet, but with the # sign at the beginning and the number of the backup copy at the end. E.g. if your sheet is named Sheet1, its backup name will be #Sheet1 (2).
hi, I am trying to merge row 2 into row 1. there are other columns in this row that I don't want affected by the merger. Also, is it possible to do this in bulk?
1001 LEBANON RD Nashville TN 372102913
1001 LEBANON RD Nashville TN 372102913 Service Nearby
Thank you for using the Merge Cells tool.
If I understood your question correctly, the solution could be to select the columns you want to merge using the Ctrl key and to omit (not select) the columns you do not want to be merged. Please let me know if this helped!
hI TODAY WE PUECHASED ABBLEBITS MERGE CELL , BUT i HAVE A hUGE REPORT AND STILL I HAVE TOMERGE THEM ONE BY ONE , CAN YOU TELL ME SOME TRICKS ?
Thank you for using our product and for your question. Could you please describe your task in more details and send your book to email@example.com? Our support team will find the most energy-saving way to solve your problem.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!