How to Combine
First and Last Name in
Google Sheets

Open your Google Sheets document and locate the column that contains the first and last names you wish to combine.

Insert a new column where the combined names will be displayed, ensuring the original columns with first and last names remain intact.

Click on the first cell in the new column where you want the combined name to appear.

Type the formula =A2 & " " & B2 (assuming the first name is in column A and the last name is in column B). This will combine the first name and last name with a space in between.

Press Enter to apply the formula, and the full name will appear in the selected cell.

To apply the formula to other rows, drag the small square in the corner of the cell down to fill the column with combined names.