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. Merge Cells Wizard can be used each time you need to join values from several cells to one , when you need to merge several cells keeping all data.

Free Download
Free 15-day trial version, 9/8/2014

How to combine columns in Excel

  1. Select the columns you want to merge in Excel worksheet.
    Select cells with the values you want to merge by row
  2. Click the Merge Cells Wizard icon Merge Cells for Excel icon.
  3. Click on the down arrow next to the Merge selected cells field and select row by row from the drop-down list.
    Click on this arrow and select row by row option from the drop-down list
  4. If you want to have the merged values separated by a comma, space or any other character, you can choose the separator in the Separate values with section. There is a set of standard separators to choose from; just select the one you need.
    Choose a separator in this section
    If you want to use a different character or a character set, enter it in the Other field. The values you enter in the Other field are saved. Next time you use the add-in, you can see them in the Other drop-down list.
    Enter or pick a custom separator
  5. To select the location for the resulting values, click the arrow next to the Place the results to field. You will see a drop-down list with two options: left cell and right cell.
    Select the location for the merged values
  6. Check the Clear the contents of selected cells checkbox to delete the values in the selected cells after merging them.
    Delete the values that were joined Clear the contents of the cells after the merge
  7. If you want to combine the selected cells by row, tick the Merge all areas in the selection checkbox.
    Merge the selected cells Merge all areas in the selection
  8. To avoid empty values in the results, exclude empty cells from join by checking the Skip empty cells option.
    Skip empty cells when merging values
  9. If you want to wrap the text in the cell with the results, check the Wrap text check box.
    Wrap text in the cell with the results
  10. If you want to keep a copy of the existing worksheet as is, check the Create a backup copy of the worksheet check box. A new worksheet with a copy of your original data will appear in the workbook after the merge.
    Tick this option to create a backup copy of the worksheet Create a backup copy of your list
  11. Click the Merge button The Merge button button to combine values from the Excel cells.

See also

How to join several rows into one

  1. Select the rows you want to join in Excel workbook.
    Select cells with the values you want to join by column
  2. Next to the Merge selected cells field, click on the down arrow and select column by column from the drop-down list.
    Click on the arrow and select Column by column from the drop-down list
  3. Select a delimiter if you want to have the combined cell values separated.
    Choose a separator in this section
  4. Select the location for the resulting values in the Place the results to field. It can be the top cell or the bottom cell of each column in the selected range.
    Choose the location for the resulting values
  5. Choose additional options and click the Merge button.

See also

How to merge multiple Excel cells into one

  1. In your Excel worksheet, select the text cells you want to combine into one cell.
    Select cells with the values you want to merge into one cell
  2. In the Merge selected cells field, select in one cell.
  3. Choose the necessary separator.
    Choose a separator in this section
  4. In the Place the results to field, select the location for the results:
    • The top-left corner
    • The top-right corner
    • The bottom-left corner
    • The bottom-right corner of the selected range
    Select the location for the results here
  5. Pick the necessary additional options and click the Merge button to combine multiple text cells into one.

Featured customers

Ablebits.com featured customers
 
Contact us
 
  Publish this message on the forum
 

Please remember that we work from 8am to 4pm GMT,
this is 4:00am to 12:00pm EST, 1:00am to 9:00am PST, and our public holidays may differ from yours.

Ultimate Suite for Excel Professionals
 
 
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
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