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
