Combine first and last names

Let's say you want to create a single Full Name column by combining two other columns, First Name and Last Name. To combine first and last names, use the CONCATENATE function or the ampersand (&) operator.

Important: In Excel 2016, Excel Mobile, and Excel for the web, this function has been replaced with the CONCAT function. Although the CONCATENATE function is still available for backward compatibility, you should consider using CONCAT from now on. This is because CONCATENATE may not be available in future versions of Excel.


Copy the following example to a blank worksheet.






First Name

Last Name






Description (Result)

=A2&" "&B2

Combines the names above, separated by a space (Nancy Davolio)

=B3&", "&A3

Combines the names above, separated by a comma (Fuller, Andrew)

=CONCAT(A2," ",B2)

Combines the names above, separated by a space (Nancy Davolio)

Note: To replace the formula with the results, select the cells, and on the Home tab, in the Clipboard group, click Copy Button image , click Paste Button image , and then click Paste Values.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

Need more help?

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.