How to merge first and last name in excel using CONCATENATE

Steps to Merge First Name and Last Name in Excel

If you have a First Name in Column A and a Last Name in Column B, follow these steps to merge them into a Full Name in Column C.

Step 1: Enter the Data

• Cell A1 → First Name (e.g., Nitish)
• Cell B1 → Last Name (e.g., Sharma)

Step 2: Use the CONCATENATE Formula

In Cell C1, enter the following formula:

=CONCATENATE(A1,” “,B1)

This formula joins A1 and B1 with a space in between.

Step 3: Press Enter

• The result in Cell C1 will be: Nitish Sharma.

Alternative Method: Using “&” Operator

You can also use the & operator for the same result:

=A1 & ” ” & B1

This method is quick and ensures proper formatting for full names! 🚀

Example:-