Join first and last name in excel

In this article, we will learn about how to join the first and last name in Excel.

In simple words, when working with names in data. Sometimes, we need to join the first and last name of the same person using excel operators and functions

& operator in Excel is used to join texts.
Syntax:

= “text1” & “text2”

This will return text “text1text2” in the cell.
001
There is an Excel function join texts
CONCATENATE function in excel joins texts in the cell.
Syntax:

= “text1” & “text2”

Let’s understand this function using it an example.
002
Here we need to join the names in the cell.

Use the formula using & operator

=A2 & " " & B2

" " : this adds up the single space between the text to be joined
003
As you can see the joined texts in the new cell.
Use the CONCATENATE function:

=CONCATENATE(A2, " ", B2)

" " : this adds up the single space between the text to be joined
004
As you can see we can do this using & operator and CONCATENATE function.

Hope you understood how to join first & last name in Excel. Explore more articles on Excel text functions here. Please feel free to state your query or feedback for the above article.

Related Articles:

Join first and last name in excel

Popular Articles:

The VLOOKUP Function in Excel
COUNTIF in Excel 2016
How to Use SUMIF Function in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.