Join multiple Excel cells into one

Combine Excel cells, columns and rows keeping all values

Merge cells in Excel, combine columns, rows.

Merge Cells is an add-in for Microsoft Excel that can combine multiple text cells in a snap. It can be used each time you need to join values from several cells to one, or when you need to merge several cells keeping all data.

Free Download
7-day fully functional version

How to combine columns in Excel

  1. Select the columns you want to merge in your Excel worksheet.
  2. Click the little arrow of the Merge Cells icon and select the option to Merge Columns into One. Select cells with the values you want to merge by row The range you selected on step 1 will be displayed at the top. You can edit it manually or use the select range icon to pick the right cells in your table. You will also see that the field How to merge is pre-set to columns into one for you.
  3. Specify the delimiter to use between the merged values in the Separate values with There is a set of standard separators to choose from: a space, line break, comma, and semicolon; but you can enter any combination of characters into the field or leave it blank to stitch the values together. The delimiters you enter manually are saved in the drop-down list for the next time you use the add-in. Choose a separator in this section
  4. Choose destination cells for the resulting values in the Place the results to drop-down list with two options: left column and right column.
  5. Use 5 additional options to adapt the results to your table:
    • Check the Clear the contents of the selected cells checkboxto delete the source values after merging them. Clear the contents of the cells after the merge
    • 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
    • Disregard blanks to avoid extra delimiters in the results by using the Skip empty cells option.
    • If you want to make the combined record visible in Excel, check the Wrap text check box.
    • We recommend selecting the option to Create a backup copy of the worksheet to get a copy of your current table as is.
  6. Click the Merge button to combine values from the selected columns in Excel.

How to join several rows into one

  1. Select the rows you want to join in Excel workbook.
  2. Click the little arrow of the Merge Cells icon and select the option to Merge Rows into One. Select cells with the values you want to join by column The selected range will be displayed at the top. You can edit it right in the field or use the select range icon to pick other rows in your table. The field How to merge will be pre-set to rows into one for you.
  3. Use the Separate values with field to select or enter a delimiter for the combined records. You can choose from standard ones like space, line break, comma, and semicolon, type in any combination of separators, or leave the field blank to stitch values together. The entered delimiters will appear in the drop-down list the next time you use the add-in. Click on the arrow and select Column by column from the drop-down list
  4. Select the top row or the bottom row for the resulting values in the Place the results to drop-down list.
  5. Choose additional options that meet your needs:
    • Choose to Clear the contents of the selected cells to remove the source values after joining them.
    • To combine the selected cells in addition to their values, check the Merge all areas in the selection checkbox.
    • Ignore blanks to avoid extra separators in the results with the help of the Skip empty cells option.
    • To make the combined record visible in Excel, choose to Wrap text.
    • We recommend selecting the option to Create a backup copy of the worksheet to get a copy of your current table as is.
  6. Click Merge to join values from the selected rows in Excel.

How to merge multiple Excel cells into one

  1. Select the cells to combine into one in your Excel table.
  2. Click the little arrow of the Merge Cells icon and select the option to Merge Cells into One. Select cells with the values you want to merge into one cell The range with the cells you selected on step 1 will be displayed at the top, you can modify it manually or click the select range icon to change it. The option to merge cells into one for will be pre-selected for you in the How to merge field.
  3. Select one of standard delimiters for the values in the Separate values with field, enter your own, or leave the field blank.
  4. Select the location for the results in the Place the results to field: the top-left cell, the top-right cell, the bottom-left cell, or the bottom-right cell of the selected range. Select the location for the results here
  5. Pick the necessary additional options:
    • Delete the merged values with the help of Clear the contents of the selected option.
    • Choose to Merge all areas in the selection to turn the selected range into one cell.
    • Avoid getting extra separators when merging values by checking off Skip empty cells.
    • Select the option to Wrap text to make the joined values visible in your worksheet.
    • We always recommend choosing to Create a backup copy of the worksheet to get a copy of your table as is.
  6. click the Merge button to combine multiple text cells into one.

Featured customers

Ablebits.com featured customers
 
Contact us
 
  Publish your message on our support forum
 

Our working hours: 0am to 10am PST; 3am to 1pm EST; 8am to 6pm CET.

Ultimate Suite for Excel Professionals
 
 
60+ professional tools for Excel 2016-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
 
 
Excel add-ins and Outlook tools - Ablebits.com