Combining or merging the first and last names in an Excel spreadsheet or workbook requires using the CONCAT and Ampersand functions or formulas. You can also use ...
I traded the static results of Flash Fill for dynamic formulas that update automatically.