how can i merge cells in excel without losing data

Merge Cells/Rows/Columns without losing Data Split Cells Content Combine Duplicate Rows/Columns.Super Formula Bar (easily edit multiple lines of text and formula) Reading Layout (easily read and edit large numbers of cells) Paste to Filtered Range.Reuse: Quickly insert complex formulas, charts and anything that you have used before Encrypt Cells with password Create Mailing List and send emails.The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by Have a Free Trial!ĭemo: Combine Multiple Columns without Losing Data in Excel

The Combine (Columns or Rows) feature of Kutools for Excel supports more combination scenarios in Excel. Then click Ok to combine multiple columns into one column without losing data. You can keep or delete contents from those combined cells, and you can also merge those combined cells. (4) Specify how you want to deal with the combined cells.

(3) Specify the cell you want to place your combined result (2) Specify a separator for the combined data, here I select the Space option (1) Select Combine columns under To combine selected cells according to following options In the Combine Columns or Rows dialog box, specify the options as follows: After installing Kutools for Excel, please select the columns of data that you want to merge, and then click Kutools > Combine. Full feature free trialģ0-day, no credit card required! Get It Nowġ. You can use the third party add-in Kutools for Excel to quickly merge multiple columns.ģ00 handy tools for Excel. Merge columns of data into one without losing data by CONCATENATE For example, the date “” will be merged as “43511”, the percentage “5.79%” will be merged as “0.0579” etc. (3) Both formula will clear the number formatting in the merging results. (2) To remove formulas from the merging results, you can copy the merging results firstly, right click the range of merging results, and select Paste > Values in the context menu as below screenshot shown, or Apply Kutools > To Actual to remove formulas but keep the merging results with only one click. (1) In both formulas, A2, B2, and C2 are cells in the first row you will merge into one, and you can change them as you need. In Cell D2, please enter the formula =A2&' '&B2&' '&C2, and then drag the AutoFill handle down to apply the formula to other cells in the active column. In Cell D2, please enter the formula =A2&B2&C2, and then drag the AutoFill handle down to apply the formula to other cells in the active column.Īnd the columns of data have been merged into one column. If you need to merge multiple columns of data into one column without any data losing, you can apply formulas to deal with it in Excel.

How can i merge cells in excel without losing data