How To Merge First And Last Name In Excel

To merge the first and last name in Excel, use the formula “=A1&” “&B1″ where A1 is the cell containing the first name and B1 is the cell containing the last name, and the output will be displayed as ”.

In today’s digital age, organizing data efficiently is essential, especially when dealing with large sets of information. One common task that often arises is merging first and last names in Excel. Whether you are working with a customer database, employee records, or any other dataset, merging first and last names can help simplify your data analysis and enhance the overall productivity of your work. In this blog post, we will explore various techniques and methods to merge first and last names in Excel, providing you with the necessary skills and knowledge to tackle this task effectively. So, let’s dive in and learn how to streamline your data with this essential Excel feature.

How To Merge First And Last Name In Excel: Step-by-Step


Step 1: Open Excel Sheet

To access your data, locate the Excel sheet and make sure the first and last names are arranged in distinct columns. You can assign Column A for the first names and Column B for the last names, ensuring a clear separation for easy analysis and manipulation.

Next Step

Step 2: Select an Empty Cell

Once you have selected the desired empty cell, usually located in Column C when your first and last names are in Columns A and B, you can merge the names by using a formula or function. This process combines the first and last names into a single cell, simplifying the organization and presentation of your data.

Next Step

Step 3: Enter Concatenate Formula

To combine the first name and last name in a cell, use the CONCATENATE function by entering the formula =CONCATENATE(A1, ” “, B1) in the selected cell. Replace A1 and B1 with the respective cell references for the desired names.

Next Step

Step 4: Press Enter

Once you have accurately entered the formula, simply hit the Enter key to activate it. Your selected cell will now display a combination of the first and last names with a space as a separator. This merging of names makes it easier to manage and analyze data, ensuring clarity and organization in your spreadsheets.

Next Step

Step 5: Apply to All Rows

By using the Fill Handle, you can easily apply the formula to all rows of data in just a few clicks. Hover over the bottom right of the cell until the cursor changes to a cross, then left click and drag down to extend the formula to all rows.


In conclusion, merging first and last names in Excel is a simple task that can be accomplished using different techniques. Whether you prefer using text functions or formulas, Excel offers multiple options to achieve the desired outcome. By following the step-by-step guide outlined in this blog post, you can easily combine first and last names into a single cell or column. This will not only save you time but also help streamline your data entry processes. So go ahead and start merging those names in Excel, and enjoy the benefits of a cleaner and more organized spreadsheet. Happy merging!

Table of Contents