Excel

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

Simplified By Me

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.

Published by Simplified By Me

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

  9. Pingback: ReBlog: How To Combine Data ...Concatenate Function? | Excel | Tutorial - BovarysComplaint ♋️

Leave a comment

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