To merge or combine the first and last names in Excel you can make use of the CONCAT Ampersand, Flash Fill or TEXTJOIN functions or formulas.

You can combine text from multiple cells into one cell in Excel using the Ampersand symbol (&) or by using the CONCATENATE function.

Excel mimics the capitalization and punctuation you use, so enter the names exactly as you want them to appear. Begin typing the next first and last name in the next cell in column C.

Alternatively, you can merge the values of aligned cells, such as combining first and last names, and then locate duplicates based on the combined data.

You can merge cells in Excel by using a simple drop-down menu, which will let you merge cells in a variety of ways. Here's how to use it.