Merging firstname/last name into one field

To combine first and last names, use the CONCATENATE function or the ampersand (&) operator.

1. How to combine last name and first name in Excel with a comma?

How to combine last name and first name in Excel with a comma?

Select the cell containing the last name (B2). In our example, your formula should now be: =CONCATENATE (A2, ,B2). 10. Press the Return Key.