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.

Responses

ISOLINA MIRANDA/ANNA FLORES says:
June 15, 2018 at 2:05 pm

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 ?

Reply

Hi!
Thank you for using our product and for your question. Could you please describe your task in more details and send your book to support@ablebits.com? Our support team will find the most energy-saving way to solve your problem.

Reply
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

Reply

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.

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

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

Reply

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.

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

Hello,

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.

Reply

Hi!
Thank you for choosing our product. I am sorry about the problems you experience with it.
Please contact us at support@ablebits.com 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.

Reply

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

Reply

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.

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

Please tell me the Shortcut key of Merge Cells

urgent please

Regards
Ashok Verma

Reply

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.

Reply

Ask a question (posted publicly)

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 support@ablebits.com.
Privacy policy Terms of use Contact us

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

Ultimate Suite 2018.5 for Excel
60+ professional tools for Excel 2019-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard