Exceljet

Quick, clean, and to the point

Join first and last name

Excel formula: Join first and last name
Generic formula 
=first&" "&last
Summary 

To join separate first and last names together into a single full name, you use concatenation. In the generic version of the formula above, first is first name, and last is last name. In the example shown, the formula in cell D5 is:

=B5&" "&C5

The result is the text in B5 joined to the text in C5, separated by a space.

Explanation 

The ampersand character (&) is a special operator in Excel that is used for concatenation. Concatenation is just a fancy word for "join". In the formula, the text in B5 "Susan" is being joined to a space character (" ") and then to the text in cell C5, "Chang".

When you use concatenation in a formula, be sure to enclose literal text in double quotes (""). Do not enclose the ampersand (&) in quotes, unless you want it to appear in the final result.

With CONCATENATE

You can also use the CONCATENATE function to join text like this:

=CONCATENATE(B5," ",C5)

The CONCATENATE function keeps things tidy, but the ampersand creates shorter, more flexible formulas.

Author 
Dave Bruns

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.