How to Combine First Name and Last Name in Excel?

Use the formula `=A2&” “&B2`

Use the formula `=CONCAT(A2,” “,B2)`

Use the formula `=TEXTJOIN(” “,TRUE,A2,B2)`

Replace `A2` with the first name cell and `B2` with the last name cell

Drag the formula down to apply it to other rows

Copy the results and paste as values if you want to keep only the combined names

Suggested for You

Trending Today