How to Merge Cells With Different Formulas in Excel

Concatenate Function
1. Open the Excel file in which you want merge cells.
2. Right-click on the column header directly to the right of the columns to be merged. For example, if the A2 contains 'First name,' B2 contains 'Middle name,' and C2 contains 'Last name,' right-click on the header for Column D.
3. Select 'Insert' from the menu that opens. This will move all columns to the right and will insert a blank column that will become the new Column D.
4. Click in cell D1 and type 'Full name.'
5. Click in cell D2 and type the following formula:=CONCATENATE(A2,' ',B2,' ',C2)This formula will return the combination of cells A2, B2, and C2 with a single space in-between each cell's contents. For example: If A2 contains 'Mickey,' B2 contains 'M' and C2 contains 'Mouse,' then the formula will return 'Mickey M Mouse.'If you do not need spaces between the cells, change the formula to the following:=CONCATENATE(A2,B2,C2)The formula will return 'MickeyMMouse.'
6. Copy and paste the formula down all rows you want to merge.
Function
7. Complete Steps 1 through 4 from Section 1.
8. Click in cell D2 and type the following formula:=SUM(A2' 'B2' 'C2)This will return 'Mickey M Mouse' in cell D2.
9. Copy and paste the formula to all rows in which the data needs merged.