All courses available in-class or via remote login

Microsoft Excel list with names

Best Use - "Concatenate" Function

June 01, 2017

The Concatenate Function

Concatenate is one of the most effective ways of combining data in Microsoft Excel.

Fundamentally there are two ways in which you can combine data in Excel spreadsheets, you can:

  • Merge cells or,
  • Concatenate cell values

 

When you merge cells, you are “physically” merging two or more cells into a single cell. As a result, you have one larger cell that is displayed across multiple rows and/or columns in your worksheet.

 

When you concatenate cells in Excel, you combine only the contents of those cells. Strictly speaking, concatenation in Excel is the process of joining two or more values together. This method is often used to combine a few pieces of text that reside in different cells (technically, these are called text strings or simply strings) or insert a formula-calculated value in the middle of some text.

 

Below is a short tutorial on how to effectively use the concatenate function:

 Step 1:

Consider the following list that has both First & Last name columns. We will use concatenate function to combine both the names to create a "Full Name column".

Step 2:

excel exert

Select a cell (D2) where you want to put your Full Name. Then click the Insert Function command in Formula Tab and find Concatenate Function. Click OK.

Step 3: 

excel exert

The CONCATENATE dialog box pops up on the screen and the Formula Name appears in the cell. Notice that, this function has two arguments
 

Step 4: 

excel exert

Select first argument (Text1) and then click on First Name (Brian). Address of the cell (B2) appears in the box.

 

Step 5:

excel exert

Select the second argument (Text2) and notice that a third argument (Text3) automatically appears in the dialog box. Type “ “ in the box. By doing this, we instruct our function to put one space between the names.

 

Step 6: 

Now select 3rd argument and click on Last Name (Houson). Address of the cell (C2) pops up in the tab.



 

Step 7:



 
Click OK and you will see both names have been combined with a space in between.

 

Step 8:

excel exert

 
Point towards bottom right corner until you see a four-headed black arrow and double click. Your entire column is populated with Full Names!



So there you have it! A simple and effective way on how to use the concatenate function. Thanks for reading!

Contact Us

What is Remote Training?

Valued by Individuals

4.72 / 5
Over 26985 Reviews
Good knowledge and very useful. -Excel Intermediate Remote Online
Liliana - Excel Intermediate, .
The instructions were clear and provided advice on pivot tables and graphs which found very helpful. -Excel Intermediate Remote Online
Dayle - Excel Intermediate, .
Very informative and easy to follow and understand. -Excel Intermediate Remote Online
Cindy - Excel Intermediate, .
Very well presented, Steven was very patient and explained things very well. was a very informative day. -Excel Intermediate Remote Online
Katherine - Excel Intermediate, .
Very informative course, well presented and I will use a lot of this information -Excel Intermediate Remote Online
Valerie - Excel Intermediate, .
Steven was a great teacher he was very patient and did everything step by step so it wasn't confusing. Would recommend this course to someone who is wanting to learn about excel. -Excel Intermediate Remote Online
Maddison - Excel Intermediate, .
Steven was very patient and went back to re-do steps if we got confused. Learnt a lot and was very informative. -Excel Intermediate Remote Online
Kim - Excel Intermediate, .
Very informative - expanded on my knowledge. Some good tips were provided regarding shortcuts. -Excel Intermediate Remote Online
Michelle - Excel Intermediate, .
Very informative course! -Excel Intermediate Remote Online
Julie - Excel Intermediate, .
Steven was a great trainer -Excel Intermediate Remote Online
Michelle - Excel Intermediate, .
Thanks a good fast paced course with a knowledgable trainer -Excel Intermediate Remote Online
Vicki - Excel Intermediate, .
Really informative course with Jason. Went at a good pace and constantly asked if we had any questions. -Excel Intermediate Brisbane
Roland - Excel Intermediate, .
Great session! Very informative. Ken was a great presenter, very patient and helpful. -Power BI Intermediate Melbourne
Donna - Power BI Intermediate, .
xlnt presenter -Excel Intermediate Brisbane
Neal - Excel Intermediate, .
Ken is a very good teacher and the whole training course is very informative and enjoyable. -Power BI Intermediate Melbourne
TUAN - Power BI Intermediate, .
Great day. Learnt a lot of new info about how to better use excel and save myself a lot of time trying to figure things out. Will reduce my workload! -Excel Intermediate Brisbane
Natalie - Excel Intermediate, .
Thought it was great! Very engaging considering completed remotely. Definitely helpful. Thank you! -Power BI Intermediate Melbourne
Lauren - Power BI Intermediate, .
Thank you for the course. Very clear and concise. I would definitely recommend the intermediate course for people with beginner experience. -Power BI Intermediate Melbourne
Matthew - Power BI Intermediate, .
Excellent course, a lot of information to take in over a day but very useful and feel confident enough to play around PBI on my own. Facilitator was very engaging and entertaining, so helped us stay tuned throughout the day. -Power BI Intermediate Melbourne
Iantha - Power BI Intermediate, .
Great pace, good examples and easy to follow. -Power BI Intermediate Melbourne
Tania - Power BI Intermediate, .

Trusted by Business

Procured by Government

Awards and Accreditations

Nexacu offices Australia

Follow us