EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Tips Combine First and Last Name in Excel
 

Combine First and Last Name in Excel

Ashwani Jaiswal
Article byAshwani Jaiswal
Madhuri Thakur
Reviewed byMadhuri Thakur

Updated August 21, 2023

Feature Image

 

 

Combine First and Last Name in Excel

In this article, we will learn about Combine First and Last Name in Excel. While doing some tasks, such as creating a customer database, it is very important to keep all the customer’s first and last names in a different column and combine those to have a proper track. By this, filtering the data becomes easy.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

How to Combine First and Last Name in Excel?

Combining the first and last names in Excel is very simple and easy. Let’s understand how to combine the first and last name in Excel with some examples.

You can download this Combine First and Last Name Excel Template here – Combine First and Last Name Excel Template

Combine First and Last Name in Excel – Example #1

There are two ways of combining First name and Last name in Excel. This can be performed in all versions of Excel. Here are some sets of First and Last names in the table below.

Table Set

Now for combining first and last names, go to the cell where we need to see the output. This table has already defined a column of Full Name, as we can see above. Type “=” (Equal) sign to go into edit mode of that cell. Select the First name, insert the “&” (Ampersand) sign, and then select the Last name.

Insert "&" (Ampersand) sign

Once done, press the Enter key.

Combine First and Last Name Example 1-3

Drag the applied formula in all the cells below. We get the output as shown below.

Combine First and Last Name Example 1-4

As we can see, the results are incorrectly formatted. There should be a space between the First and Last name. So for inserting a space, follow the same procedure, but instead of selecting the cell, add space as shown below.

Adding Space in Formula

In the above screenshot, we have separated the First and Last name with space. And used space as text, so to add it to the formula, we need to frame it with inverted commas/double quotes (“”). Any type of text which types manually should be framed with inverted commas as we did for space between the First and Last name.

Combine First and Last Name Example 1-6

Drag the applied formula in all the cell below. We get the output as shown below.

Combine First and Last Name Example 1-7

This technique allows us to add any kind of text, not First and Last names. But I was combining different cells which can be used for any type of work.

Combine First and Last Name in Excel – Example #2

Another method of combining the First name and Last name is Concatenation in Excel. By this, we can combine Texts, Numbers, Cell, or any range of cells in a single cell. For this, we have some sets of First and Last name, as shown below.

Combining First name and Last name

In the above example, we also have Salutation and Middle name, along with the First and Last Name. Now for combining the First and Last name, go to the cell where we need to see the output and click on the Insert Function option, which is located beside the formula bar as shown below.

Inserting Function

This is a common function; it will probably be located under the ALL category. Once we click on it, we will get an Insert Function window. From there, search for CONCATENATE function and click on Ok, as shown below. the

Combine First and Last Name Example 2-3

After that, we will get the Function Arguments window. In that, select the cell in proper sequence the way you want to see the First and Last name, separated by space (“”). There is no need to add inverted commas for space, as it will automatically consider them once we move to the next cell. Once done, click on Ok.

Also, to check whether our framed syntax is correct, we will get the output at the bottom left of the Function Arguments box, as shown below.

Functions Arguments

We will then get the result.

Combine First and Last Name Example 2-5

Now drag the framed formula to all relevant cells, as shown below.

Combine First and Last Name Example 2-6

Through this, we can frame any content they have, regardless.

Combine First and Last Name in Excel – Example #3

This is another method of combining the First and Last name with the CONCATENATION Function in Excel. We will use the same data set as example-2. For this, go to the cell where we want to see the result. And type the “=” sign to enable the inbuilt functions of Excel. Now search and select CONCATENATE, as shown below.

Concantenate

Now use the same syntax which we used in example-2. Select the cell with text and separate those cells with space with inverted commas (“”). Covering the space or entering text manually makes it useable in the formula, which we have already seen in example-1.

Combine First and Last Name Example 3-2

Now Drag the framed formula to all relevant cells as shown below.

Framed Formula

As we can see in the above screenshot, we have combined First and Last name along with Salutation and Middle name, separated by space.

Pros

  • The data looks organized.
  • Maintaining customer records is very helpful.
  • With the help of the Concatenate function, we can arrange and combine any kind of data.
  • Once we applied for the formula, we can drag and use it anywhere.

Things to Remember

  • If you will use data in other files, always paste a special formula or convert it into text before pasting it into other files.
  • Spaces and Texts are required to be covered with inverted commas/double quotes (“”).
  • Remember the proper sequence of selecting the cells to arrange data properly.

Recommended Articles

This has been a guide to Combine First and Last Names in Excel. Here we discuss how to Combine First and Last names in Excel, practical examples, and a downloadable Excel template. You can also go through our other suggested articles –

  1. Count Names in Excel
  2. Excel Named Range
  3. Name Box in Excel
  4. VBA Name Worksheet

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Combine First and Last Name Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Combine First and Last Name Excel Template

EDUCBA

डाउनलोड Combine First and Last Name Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW