Skip to main content

Effortlessly Merge Excel Cells, Rows & Columns—Zero Data Loss Guaranteed

Author: Kelly Last Modified: 2025-06-05

Kutools for Excel

Boosts Excel With 300+
Powerful Features

Kutools for Excel offers a powerful Combine Rows, Columns or Cells without Losing Data feature that allows you to quickly merge text across multiple columns, rows, or cells without losing data. Instead of manually concatenating values with formulas (e.g., using “&” or CONCATENATE), the Combine tool streamlines the process with a few clicks, providing flexible options for separators, handling blank cells, and placing results in place or into a new column/row. With this powerful feature, you can quickly process following operations in Excel:

Merge multiple columns into one—keep all your data intact

Combine multiple rows into a single row—zero data loss

Combine selected cells from multiple rows & columns into one cell


Key Advantages of the feature


Merge multiple columns into one—keep all your data intact

Suppose you have columns A (First Name), B (Last Name), and you want to merge them into column D (Full Name), separated by spaces. To finish this task, please do as this:

1. Select the data range that you want to combine.

2. Click KutoolsMerge & Split > Combine Rows, Columns or Cells without Losing Data, see screenshot:

click Combine Rows, Columns or Cells without Losing Data feature

3. In the dialog box, specify the settings as follows:

  • Select the Combine columns option in the To combine selected cells according to following options section.
  • Specify a separator to delimit the combined contents.
  • Decide what to do with source cells. (here are three options you can use :)
    • Keep contents of combined cells: it won't delete the contents from the original cells.
    • Delete contents of combined cells: it will delete the contents from the original cells.
    • Merge the combined cells: it will delete the contents from the original cells and merge them.
  • Specify the output cell, under the Place the results to section, select Other Cell option and click to select a cell to output the result. (you can also select Left cell or Right cell to output the result)
  • Finally, click OK button.
    specify the options in the dialog box

Kutools instantly concatenates each row’s values from columns A–B into column D, separated by spaces. See screenshot:

combine columns by kutools


Combine multiple rows into a single row—zero data loss

1. Select cells which you want to merge based on rows as follows, and then apply the utility by clicking Kutools > Merge & Split > Combine Rows, Columns or Cells without Losing Data.

click Combine Rows, Columns or Cells without Losing Data feature

2. In the dialog box, specify the settings as follows:

  • Select the Combine rows option in the To combine selected cells according to following options section.
  • Specify a separator to delimit the combined contents.
  • Decide what to do with source cells. (here are three options you can use :)
    • Keep contents of combined cells: it won't delete the contents from the original cells.
    • Delete contents of combined cells: it will delete the contents from the original cells.
    • Merge the combined cells: it will delete the contents from the original cells and merge them.
  • Specify the output cell, under the Place the results to section, select Other Cell option and click to select a cell to output the result. (you can also select Top cell or Bottom cell to output the result)
  • Finally, click OK button.
    specify the options in the dialog box

Kutools instantly concatenates values from each column into designated cells, separated by spaces. See screenshot:

combine rows by kutools


Combine selected cells from multiple rows & columns into one cell

Combining selected cells—whether they span multiple rows, columns, or both—into a single destination cell allows you to quickly aggregate scattered data. Instantly, Kutools concatenates each selected cell’s content into one location—preserving the original values and formatting—so you can create unified lists, summaries, or labels in seconds.

1. Select cells which you want to merge based on rows as follows, and then apply the utility by clicking Kutools > Merge & Split > Combine Rows, Columns or Cells without Losing Data.

click Combine Rows, Columns or Cells without Losing Data feature

2. In the dialog box, specify the settings as follows:

  • Select the Combine into single cell option in the To combine selected cells according to following options section.
  • Specify a separator to delimit the combined contents.
  • Decide what to do with source cells. (here are three options you can use :)
    • Keep contents of combined cells: it won't delete the contents from the original cells.
    • Delete contents of combined cells: it will delete the contents from the original cells.
  • Specify the output cell, under the Place the results to section, select Other Cell option and click to select a cell to output the result. (you can also select Current cell to merge the cells data into current cells)
  • Finally, click OK button.
    specify the options in the dialog box

All cells you selected are combined into one single cell at once, See screenshot:

combine range of cells by kutools

Tips:

1. This utility supports CTRL+Z undo.

2. Use formatted values: it will keep the formatting of the values after merging the cells. For example, if the value in cell is "100", then you apply cell formatting to this cell and change the "100" into "$100.00 USD", so the shown value in cell is "$100.00 USD". If you checked this "Use formatted values" option, the merged content will be "$100.00 USD"; if unchecked this option, the merged content will be "100'.

Demo: combine (merge) multiple columns or rows in Excel

 
Kutools for Excel: Over 300 handy tools at your fingertips! Enjoy permanently free AI features! Download Now!

Productivity Tools Recommended

Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs — no more cluttered windows. Know more...

Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...


Kutools for Excel

Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.

🌍 Supports 40+ interface languages
✅ Trusted by 500,000+ users and 80,000+ businesses worldwide
🚀 Compatible with all modern Excel versions
🎁 30-day full-featured trial — no registration, no limitations
Kutools for Excel RibbonKutools for Excel Ribbon