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.

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

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 )

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.