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.
