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 first.last@company.com. Here is what the result would look like.

Excel concatenate email example

Excel concatenate email example list

Advertisements

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.
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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s