How to Combine First and Last name in Google Sheets(Quick & Easy Guide)

In this tutorial you will learn How to combine first and last name in Google sheets.

To Combine First and Lastname in Google Sheets :

How to Combine First and Last name in Google Sheets : Step by Step Guide

Here are the steps to Combine First and Last name in Google Sheets

Create three columns with Firstname ,Lastname and Fullname as header .Now specify the first and lastnames that you want to combine as shown below.

Enter the following formula in the first cell of the fullname name column C2:

=A2 & " " & B2

where A2 and B2 represent the locations of the first and last names for the current row.

A gap between the quote marks must be included in the formula in order for the first and last names to not be combined.

Press enter to apply the formula on Cell C2 then confirm the suggested auto-fill to apply the formula on the remaining cells in Fullname Column C2.

Now Firstname and Lastnames have been combined and you have the result on Column fullname.

Another method to combine firstname and lastname in Google Sheets is using concatenate function .

To combine first name and lastname using concatenate function follow the below steps .

Type the following formula in the Column cell where you need to get the fullname and press enter key.

=CONCATENATE(A2,B2)

Your firstname and lastnames will be combined with the result being displayed in Column C

In the above tutorial we have walked your through a step by step tutorial using which you can quickly combine first and lastname in Google Sheets.

We hope this tutorial on How to Combine First and Last name in Google Sheets was useful.