We can combine first and last name on a spreadsheet by applying a formula that combines the first name and the last name. This tutorial will guide all levels of excel users on how to merge names in excel.

Figure 1: How to combine last name and first name

Input the First and last names

We will make a list of the first and last names and create the last column for the full name.

Figure 2: Insert names

  • We will click on Cell C4 and we will input the formula =A4&” “&B4. We will then press Enter to display the full name in Cell C4

Figure 3: Formula for name merge

  • We will drag the fill handle (the small box at the bottom-right of Cell C4 in figure 3) to copy the formula to Cell C8.

Figure 4: Combine names in excel