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.

Modern Excel functions like XLOOKUP, TEXTJOIN, and dynamic arrays offer faster, more versatile, and error-resistant alternatives to outdated tools such as VLOOKUP, CONCAT, and OFFSET.