# How to Join Text in Excel (6 Effective Methods)

Get FREE Advanced Excel Exercises with Solutions!

While working in Excel, we often need to join multiple text strings together. Joining texts manually can be a time-consuming and inefficient way to do the task. Microsoft Excel is quite versatile software that provides us with a number of ways to join text in more efficient manners. In this article, we will discuss six effective methods to join text in Excel. So, letâ€™s start this article and explore these methods.

## 6 Efficient Ways to Join Text in Excel

In this section of the article, we will learn six efficient ways to join text in Excel. Letâ€™s say, we have the Employee List of ABC Company as our dataset. In the dataset, we have the First Name and the Last Name of the employees. Our goal is to join these two text strings and display the Full Name.

Not to mention, we used the Microsoft Excel 365 version for this article; however, you can use any version according to your preference.

### 1. Using CONCAT Function

Using the CONCAT function is one of the most efficient ways to join text. It is to be noted that the CONCAT function is available from Excel 2016 and onwards. Now, letâ€™s follow the steps mentioned below to do this.

Steps:

• Firstly, use the following formula in cell D5.
`=CONCAT(B5," ",C5)`

Here, cell B5 represents the first cell of the First Name column, and cell C5 indicates the first cell of the Last Name column.

• Following that, press ENTER.

Consequently, you will have the Full Name of the first employee as shown in the following image.

• Finally, use Excelâ€™s AutoFill feature to get the rest of the outputs.

Read More: How to Join Names in Excel (7 Quick Methods)

### 2. Utilizing CONCATENATE Function

As the CONCAT function is not available in all versions of Excel, the CONCATENATE function is available for the earlier versions of Excel. Letâ€™s use the instructions outlined below to join text in Excel using the CONCATENATE function.

Steps:

• Firstly, insert the formula given below in cell D5.
`=CONCATENATE(B5," ",C5)`
• After that, press ENTER.

As a result, you will have the Full Name of the first employee in cell D5.

• Lastly, use Excelâ€™s AutoFill option to get the remaining outputs as demonstrated in the following picture.

Read More: How to Use Join Formula in Excel (6 Practical Examples)

### 3. Applying TEXTJOIN Function

Applying the TEXTJOIN function is another efficient way to join text in Excel. Letâ€™s use the procedure discussed in the following section to do this.

Steps:

• Firstly, apply the following formula in cell D5.
`=TEXTJOIN(" ",TRUE,B5,C5)`
• Then, hit ENTER.

As a result, you will have the following output as shown in the following image.

• Now, use Excelâ€™s AutoFill feature to get the Full Names of the remaining employees.

### 4. Employing Ampersand Operator

Now, we will use the Ampersand Operator of Excel to join text strings in Excel. Now, letâ€™s follow the steps mentioned below to do this.

Steps:

• Firstly, use the following formula in cell D5.
`=B5&" "&C5`
• Then, press ENTER from your keyboard.

Consequently, you will have the Full Name of the first employee in cell D5.

• Finally, use Excelâ€™s AutoFill feature to get the remaining outputs as shown in the image below.

### 5. Utilizing Flash Fill Feature

Utilizing the Flash Fill option is another smart way to join text in Excel. The Flash Fill tool allows us to automatically fill out the data when it detects a pattern. Now, letâ€™s follow the instructions outlined in the following section.

Steps:

• Firstly, type in the Full Name of the first employee as shown in the following image.

• Now, select cell D5.
• After that, go to the Home tab from Ribbon.
• Then, click on the Fill option.
• Subsequently, select the Flash Fill option from the drop-down.

Thatâ€™s it! You will have the Full Names of all employees as demonstrated in the image below.

### 6. Incorporating VBA Macro Option

In this section of the article, we will incorporate the VBA Macro feature of Excel to join text. So, letâ€™s follow the steps discussed in the following section to do this.

Steps:

• Firstly, go to the Developer tab from Ribbon.
• After that, choose the Visual Basic option from the Code group.

As a result, the Microsoft Visual Basic for Applications window will appear on your worksheet.

• Now, go to the Insert tab from the Microsoft Visual Basic for Applications window.
• Following that, choose the Module option from the drop-down.

• Subsequently, write the following code in the newly created Module.
``````Sub joining_text()
Dim initial_rowN As Long, final_rowN As Long
With Sheets("VBA")
final_rowN = .Range("B" & Rows.Count).End(xlUp).Row
For initial_rowN = 5 To final_rowN
Sheets("VBA").Cells(initial_rowN, 4) = _
.Cells(initial_rowN, 2) & " " & .Cells(initial_rowN, 3)
Next initial_rowN
End With
End Sub``````

Code Breakdown

• Firstly, we created a sub procedure named joining_text.
• After that, we declared two variables named initial_rowN, and final_rowN and specified their data type as Long.
• Then, we applied the With statement to specify the worksheet for which the macro will run.
• Subsequently, we assigned the value of the final_rowN variable.
• After that, we used a For Next loop to join texts of the First Name and the Last Name columns and displayed them in the Full Name column.
• In this code, we used the Ampersand operator to join the two texts.
• Following that, we terminated the For Next loop.
• Afterward, we ended the With statement.
• Lastly, we terminated the sub procedure.
• After writing the code, click on the Save option.

• Then, use the keyboard shortcut ALT + F11 to return to the worksheet.
• After that, use the keyboard shortcut ALT + F8 to open the Macro dialogue box as shown in the following picture.

• Now, in the Macro dialogue box, select the joining_text option.
• Finally, click on Run.

Consequently, you will have the Full Names of all of the employees as demonstrated in the picture below.

Read More: How to Create Cross Join in Excel (3 Simple Ways)

## Practice Section

In the Excel Workbook, we have provided a Practice Section on the right side of the worksheet. Please practice it yourself.

## Conclusion

So, these are the most common and effective methods you can use anytime while working with your Excel datasheet to join text in Excel. If you have any questions, suggestions, or feedback related to this article, you can comment below. You can also have a look at our other useful articles on Excel functions and formulas on our website, ExcelDemy, a one-stop Excel solution provider.

## Related Articles

#### Zahid Hasan

Hello and welcome! Thank you for visiting my profile. I am currently employed as an Excel & VBA Content Creator at ExcelDemy. My most recent academic qualification is a BSc (Eng) from the Bangladesh University of Engineering and Technology. Industrial and Production Engineering was my major. I constantly attempt to think creatively and find a simple answer.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF