Join first and last names together using the concatenate function in Excel

Say you have a column of first and last names in Excel. Like first names in column A and last names in column B as I have below. And you want to put them together in column C. You can do this pretty easily without typing the list all over again using the concatentate function.

Select the cell you want the formula in.

Excel concatenate names

Then click the Formulas tab–>Text–>Concatenate.

Excel concatenate names list

In the function arguments box, connect the cells you wish to join. So in my example I have A2 which equal “Mark” to be first. Then I have ” ” which is a empty space inside of quotations to be next. Finally I have B2 which equals “Thompson” to be last. Once I hit OK I can drag the autofill button down (little black square in the corner of the cell) to copy the formula to the next rows.

Excel concatenate final

Another cool tip is that I could generate a quick list of emails if these people all have the same pattern. For example lets say that everyone has the pattern Here is what the result would look like.

Excel concatenate email example

Excel concatenate email example list


About Steve Chase

I want to help you work in your business, so you can work on your business. I want to help you achieve your goals and help you have a successful small business journey. I understand that keeping up with the latest technology and cloud based computer trends can be difficult, when you’re running your day to day business. But, it is crucial that you keep up with the technology and best understand your options, in order to thrive in this new era of online business. I can help you discover the right software and tools for your business, train your team on how to use them, and mentor you to best serve and delight your customers. My certifications include: QuickBooks ProAdvisor, Microsoft Office Specialist Master, and OntraPort Certified Consultant. Please contact me on my new website at
This entry was posted in Excel and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s