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.

Combining text from multiple cells into one cell in Excel is very useful for users like users who want to create a mailing list, prepare data for import, etc.

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.

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.

Two, we can instruct Excel to combine the first and last names into one cell, again with just one formula. In the first scenario, we create a unique list of customers that pulls both the first and ...