How to Combine Two Rows in Excel?

Select the cells where you want the combined result to appear

Use a formula such as `=A1&B1`

Use a separator with `=A1&” “&B1` or `=A1&”, “&B1`

Press Enter

Copy the formula down for other rows if needed

Use `CONCAT` or `TEXTJOIN` if you want to combine more than two cells

Copy the result and paste as values if you want to replace formulas with text

Use Flash Fill if Excel can detect the pattern automatically

Suggested for You

Trending Today