How To Combine Text From Two Cells In Excel?

Use the ampersand operator: `=A1&B1`

Add a space between cells: `=A1&” “&B1`

Add any separator you want: `=A1&”, “&B1`

Use the CONCAT function: `=CONCAT(A1,B1)`

Use the TEXTJOIN function with a delimiter: `=TEXTJOIN(” “,TRUE,A1,B1)`

Use the CONCATENATE function: `=CONCATENATE(A1,B1)`

Copy the formula down to combine other rows

Suggested for You

Trending Today