How To Merge Columns Data In Excel?

Select the cells you want to merge

Go to the Home tab

Click Merge & Center in the Alignment group

Choose Merge Cells if you do not want centered text

Use CONCAT or TEXTJOIN formulas to combine data from multiple columns

Example: =A1&” “&B1

Example: =TEXTJOIN(” “,TRUE,A1:C1)

Copy the formula down for all rows

If needed, copy the results and paste as values

Use Flash Fill by typing the desired combined result and pressing Ctrl+E

Use Power Query to combine columns for larger datasets

Suggested for You

Trending Today