How To Combine Two Cells In Excel?

Select the cell where you want the combined result.

Combine with a space: `=A1&” “&B1`

Combine without a space: `=A1&B1`

Combine with a comma and space: `=A1&”, “&B1`

Combine with a line break: `=A1&CHAR(10)&B1` (then enable Wrap Text)

Combine multiple cells: `=A1&” “&B1&” “&C1`

Combine with CONCAT: `=CONCAT(A1,B1)`

Combine with CONCATENATE: `=CONCATENATE(A1,B1)`

Combine with TEXTJOIN (skip blanks): `=TEXTJOIN(” “,TRUE,A1,B1)`

Combine with TEXTJOIN (delimiter choice): `=TEXTJOIN(“,”,TRUE,A1,B1)`

Copy the formula down to other rows (if needed).