For example, suppose you imported a CSV file into Excel, with the first names in column A and surnames in column B. With CONCAT you can join them and arrange them anyway you want.

The example we've used below reads as =CONCAT (A2,” “,D2). Again, if the spreadsheet needs the formula result copied to the whole column, left-click the bottom right corner of the CONCAT cell and drag ...

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.