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