How to Join First and Last Name in Excel

In many cases, you would like to join first and last name together from separate cells in Excel. The ampersand and character function can be used to join first and last name to make a full name. This tutorial will show you how to join two cells in Excel.

Join first and last name in Excel

The formula is based on two major parts the word first represents the first name and the word last represent the last name.

Formula to join first and last name

=first&” “&last

Figure1. Join first and last name


In the figure above, the formula used for joining first and last name is:

=B5&” “&C5 for D5

=B6&” “&C6 for D6 and so on:

How the formula works

The formula works on the ampersand function which uses special character &. The & character has a wide range of significance in MS excel and is used for joining data sheets. In this formula, the first name in B5 is joined with the last name in C5 using the & or ampersand character.

Although the Ampersand is widely used and is not only short but easy to use, there is another function that can also be used to join first and last name. The other function is known as the CONCATENATE function.

The formula used in the CONCATENATE function is as follows:

= CONCATENATE (B5,” “,C4)  

Still need some help with Excel formatting or have other questions about Excel? Connect with a live Excel expert here for some 1 on 1 help. Your first session is always free. 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment