Excel

How to Combine First and Last Name in Excel

How to Combine First and Last Name in Excel

In Excel, you can combine the first and last name in a cell by using the concatenate function. The concatenate function will combine the text in two or more cells into one cell. In order to use the concatenate function, you will need to use the ampersand (&) symbol. The ampersand symbol will join the text in two cells together.

In order to combine the first and last name in a cell, you will need to type the following formula into the cell:

=concatenate(first_name, " ", last_name)

In this formula, first_name is the first name in the cell and last_name is the last name in the cell. You can also use the following formula to combine the first and last name in a cell:

=concatenate(first_name, last_name)

In this formula, first_name is the first name in the cell and last_name is the last name in the cell.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.