Merge multiple Excel cells into one

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.

Before you start

Back up your worksheet

We care about your data and suggest you always create backup copies of your files. A special option of the wizard will do that for you if you select it.

Merge several areas at once

The add-in brings together all areas in the selection, including non-adjacent ones.

Start Merge Cells

Run the add-in by clicking on its icon in the Merge group on the Ablebits Data tab:
Merge Cells icon on the Ablebits Data tab.

How to combine Excel cells, columns, and rows

The add-in's window lets you adjust the following options:
Fine-tune the options to merge data as needed.

  1. One click on the Expand selection icon highlights the entire table automatically.
  2. Click the Select range icon and you will get a dialogue box that allows you to pick the necessary cells:
    A dialogue window for you to choose the range to merge.
  3. Choose how to merge your cells:
    • Columns into one. Bring data from the cells in each row into one cell:
      Combine columns row by row.
    • Rows into one. Combine rows in each column into one cell:
      Merge several rows column by column.
    • Cells into one. Merge all selected cells into one cell:
      Bring the data from all cells into a single cell.
  4. Separate values with offers a set of standard delimiters to use between the merged values:
    • Semicolon (;)
    • Comma (,)
    • Period (.)
    • Space ()
    • Line break ()
    Tip. You can enter any combination of characters into the field or leave it blank to stitch the values together. The separators you enter manually are saved in the drop-down list for the next time you use the add-in.
  5. Choose destination cells for the resulting values in the drop-down Place the results to list:
    • Left column or right column if you merge columns.
    • Top row or bottom row when you combine rows.
    • Top-left cell, top-right cell, bottom-left cell, or bottom-right cell for when you bring all cells into one.
  6. Use 4 additional options to adapt the results to your table:
    • Check the Clear the contents of the selected cells checkbox to delete the source values after merging them:
      Clear the contents of the selected cells.
    • If you want to combine the selected cells, and not only their values, choose to Merge all areas in the selection:
      Merge all areas in the selection.
    • Avoid getting extra separators when merging values by checking off Skip empty cells.
    • Select the Wrap text option to make the joined values visible in your worksheet.
  7. We recommend choosing to Create a backup copy of the worksheet to get a copy of your current table as is.

Click the Merge button to combine values from the selected columns in Excel.


Can I create a shortcut to do this faster?


Hello Trixy,

Unfortunately, it is not possible to create a shortcut for the add-in.

Jordan Batson says:
April 10, 2020 at 2:38 am

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


Hello Jordan,

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) ?


Ekaterina Pechyonkina says:
March 3, 2020 at 8:36 am

Hi Andrew,

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.

Katerina Bespalaya says:
December 13, 2019 at 11:23 am

Hello Rebecca,

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 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.

Hello Rebecca,

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?
Thank you!


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.


Hi Abdallah,
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.


Hello Declan,
Thank you for your comment.

I'm sorry, but our add-in doesn't preserve the formatting of the merged cells.

Ashok Verma says:
April 3, 2019 at 6:52 am

Please tell me the Shortcut key of Merge Cells

urgent please

Ashok Verma


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.
Thank you.


How to merge cells without a space or character in between?


Hello Tammie,
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.

Michael Marcus says:
February 7, 2019 at 9:13 pm


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 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.

Joseph Madzelan says:
December 7, 2018 at 1:13 pm

Where is the backup copy stored? I can't find it.


Hi, Joseph,
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).

Thank you.

richard kathawa says:
October 8, 2018 at 7:11 pm

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


Hi, Richard,
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!
Thank you.

June 15, 2018 at 2:05 pm



Thank you for using our product and for your question. Could you please describe your task in more details and send your book to 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!

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at