How to automatically merge first and last names in Excel
Fill in the first and last names manually in an adjacent column for the first entry.
Start entering in the following row's name, and Excel will propose full names for the entire column.
To accept the suggestions, press Enter. Done!
Formula 1: In Excel, combine the first and last names.
Let's imagine you have one column for given name and another for surname in your worksheet, and you want to combine these two columns into one.
Here are the Excel formulas to combine first and last names in their most basic form:
=first_name_cell&" "&last_name_cell
CONCATENATE(first_name_cell," ",last_name_cell)