How To Concat In Excel?

Use `=A1&B1`

Use `=CONCAT(A1,B1)`

Use `=CONCATENATE(A1,B1)`

Use `=TEXTJOIN(” “,TRUE,A1,B1)`

Use `=A1&” “&B1`

Use `=A1&”, “&B1`

Use `=CONCAT(A1,” “,B1,” “,C1)`

Use `=TEXTJOIN(“, “,TRUE,A1:C1)`

Suggested for You

Trending Today