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
Replace `B2` with the last name cell
Copy the formula down for other rows
Use Paste Special > Values if you want to keep only the combined names