# How to Copy CONCATENATE Formula in Excel (5 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

While working in Excel, we often need to copy CONCATENATE formula to join multiple text strings. If you are finding difficulties to copy CONCATENATE formula then this article is the perfect guide for you. In this article, we will learn 5 convenient ways to copy CONCATENATE formula in Excel. So, let’s start this article and explore these methods.

## 5 Simple Methods to Copy CONCATENATE Formula in Excel

In this section of the article, we will learn 5 simple methods to copy the CONCATENATE formula in Excel. Let’s say, we have 2 sets of words in 2 different columns. Our goal is to use the CONCATENATE formula to join these and copy down the formula in the following cells.

### 1. Using Copy and Paste Command

Using the Copy and Paste command is one of the easiest ways to copy the CONCATENATE formula in Excel. Let’s follow the steps mentioned below to do this.

Step 01: Apply CONCATENATE Function

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

Here, cell B5 represents the 1st Word and cell C5 indicates the 2nd Word. Now the CONCATENATE function will join the 2 sets of words.

• Following that, press ENTER.

Consequently, the 2 sets of words will be joined together as shown in the following image.

Step 02: Copy CONCATENATE Function

• Firstly, select cell D5 and use the keyboard shortcut CTRL + C to copy the cell.

• After that, select the range of the cells D6:D11 and use the keyboard shortcut CTRL + V to paste the cell along with the formula.

As a result, the CONCATENATE formula will be copied down in the range of the cells D6:D11, as demonstrated in the following picture.

### 2. Utilizing Fill Handle

Utilizing the Fill Handle is another efficient way to copy the CONCATENATE formula in Excel. Let’s follow the instructions outlined below to do this.

Steps:

• After that, drag the Fill Handle down up to cell D11 as shown in the image below.

Consequently, the CONCATENATE formula will be copied down in the cells of the Combined Result column.

Note: You can also double-click the Fill Handle icon to get the same output.

### 3. Applying Table Format

Applying the Table format is one of the smartest ways to copy the CONCATENATE formula in Excel. Now, let’s use the procedure discussed in the following section.

Steps:

• Firstly, select the dataset and use the keyboard shortcut CTRL + T to convert the dataset into a Table.

• Then, in the Create Table dialogue box, check the field of My table has headers.
• Now, click OK.

As a result, the dataset will be converted to a table as shown in the following image.

• At this point, apply the following formula in cell D5.
`=CONCATENATE(B5&" " &C5)`
• Next, hit ENTER.

Consequently, the CONCATENATE formula will be copied in all of the cells of the Combined Result column as demonstrated in the following image.

### 4. Pasting as Formula

We can also use the Paste option to copy the CONCATENATE function as a formula in Excel. You can apply the steps mentioned below to do this.

Steps:

• Following that, select cell D5 and use the keyboard shortcut CTRL + C to copy the cell.

• Now, select the range of cells D6:D11 and go to the Home tab from Ribbon.
• After that, select the Paste option from the Clipboard group.
• Then, choose the Formulas (F) option from the drop-down.

Subsequently, the CONCATENATE function will be copied into the remaining cells.

### 5. Using Shortcut key

In Excel, we can copy the CONCATENATE formula by using a simple keyboard shortcut. Let’s use the instructions outlined below to do this.

Steps:

• After that, select all the cells of the Combined Result column.
• Then, use the keyboard shortcut CTRL + D to copy down the formula.

That’s it! The CONCATENATE function will be copied in the cells of the Combined Result column as demonstrated in the following picture.

## Practice Section

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

## Conclusion

So, these are the most common & effective methods you can use anytime while working with your Excel datasheet to copy CONCATENATE formula 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.

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