How To Merge First Name And Last Name In Excel. To combine first and last names, use the concatenate function or the ampersand (&) operator. Then click up here on the button f x, which serves to insert a function.

This will insert a space between the combined first and last names. To concatenate first, middle and last name in one cell. Combine first and last name in excel.