In Google Sheets, we combine first and last names in three ways (combining values from two cells into one cell).
This tutorial will discuss three different ways to write formulas to get the first and last names within a single cell.
Combine Both Names with an Ampersand
You can use the below steps:
- Enter equal to (=) sign in a cell.
- Refer to the cell with the first name, and enter an ampersand (&).
- Type a space using double quotation marks.
- Again, enter an ampersand and then refer to the cell with the last name.
- In the end, hit enter to get the result.
=A1&" "&B1
Use TEXTJOIN to Combine Names
With TEXTJOIN, you can quickly join values from two cells and create a full name in a single cell.
Here you have three arguments to define.
- First, you need to specify the delimiter, a value that you want to have between both names. And here we have specified a space.
- Second, you need to specify whether you want to ignore blank cells.
- Third, you need to define the range of cells where you have first and last names.
- In the end, hit enter to get the full name in the cell.
=TEXTJOIN(" ",TRUE,A1:B1)
CONCATENATE Function to Combine First-Last Name
This function works exactly like the first method we used with the ampersand. Here we use the CONCATENATE function but use the same way to combine values.
- Enter the CONCATENATE.
- Refer to the first name and enter an ampersand.
- Type a space with double quotation marks.
- Again enter the ampersand and refer to the last name.
- Close the function and hit enter to get the result.
=CONCATENATE(A1&" "&B1)