Excel

# How To Combine Data Using The Concatenate Function? | Excel | Tutorial

The Concatenate function combines text data from different cells into one. This is useful for many purposes, one common purpose is if you have your employee names in three columns Title, First Name & Surname.

In this tutorial, I am going to show you how to use the function Concatenate.

Video Guide

Instructions

In this example, we will look at combining two columns First Name, Surname

• Create or have ready that needs to be combined together.
• The Concatenate formula is =CONCATENATE(text1,text2,text3,text4,text5…….). We can type this formula in cell C2 or as appropriate to your data.
• Text1 – This will be the first name, Click on cell A2 or select the first entry under the First Name. Finish by typing a comma to close the current function.
• Text2 – This will be the space between first name and surname, enter a space in quotations using the spacebar. Finish by typing a comma to close the current function.
• Text3 – This will be the surname, click on cell B2 or select the first entry under Surname.
• If we have more than two cells to combine such as if you have a title, first name and surname then you can continue the formula as appropriate.
• Once this is done we can close the bracket then click enter and drag the formula down.
• This should now present you with the employee full names grouped together in one column.

## 12 thoughts on “How To Combine Data Using The Concatenate Function? | Excel | Tutorial”

1. Hello. I had a chance to check out your blog, I am sure that I will be visiting quite often as I work with excel quite often and didn’t know half of what I am learning from your posts. I hope you have a great week.

Liked by 1 person

2. I love your posts. They simplify everything. I need someone to do this for me for WordPress haha. Thanks. Great site

Liked by 2 people

3. This is my fav.. feels like Magic everytime I help someone with it.. and same goes with ‘text to column’ and ‘transpose paste’ 😂😂

Liked by 1 person

1. Simplified By Me says:

Thank you!

Unfortunately, Numbers will not be covered in this blog in the near future.

Like

4. travelwithash09 says:

Good content mate. Keep up the good work

Liked by 1 person

5. Thank you for this, I am working in excel a lot now and loving it.