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. 




