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.

I am going to combine the first and last names of persons in my Excel worksheet. The structure of the formula is as follows: =First Name&""&Second Name I have applied the same formula to my Excel ...