While working in Excel, we often need to **copy ****CONCATENATE**** formul**a 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.

## Download Practice Workbook

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

**Read More: ****How to Concatenate in Excel (3 Suitable Ways)**

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

- Firstly, use the
**steps mentioned in Step 01 of the 1st method**to obtain the following output.

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

**Read More: ****How to Combine Text from Two or More Cells into One Cell in Excel (5 Methods)**

**Similar Readings**

**Concatenate Cells but Keep Text Formatting in Excel****How to Concatenate and Keep Number Format in Excel****Concatenate Date/Day, Month, and Year in Excel****How to Bold Text in Concatenate Formula in Excel (2 Methods)****Concatenate Multiple Cells but Ignore Blanks in Excel (5 Ways)**

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

**Read More: ****Concatenate Multiple Cells Based on Criteria in Excel (4 Methods)**

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

- Firstly,
**use the procedure discussed in Step 01 of the 1st method**to get the following output as shown in the picture below.

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

**Read More: ****VBA to Concatenate Range with Separator in Excel (3 Ways)**

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

- Firstly,
**follow the steps mentioned in Step 01 of the 1st method**to get the following output.

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

**Read More: ****How to Concatenate Multiple Cells in Excel (7 Easy Ways)**

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

**How to Concatenate Cells with If Condition in Excel (5 Examples)****Excel CONCATENATE Showing Formula Not Result (5 Solutions)****Combine CONCATENATE & TRANSPOSE Functions in Excel****How to Concatenate Arrays in Excel (With 2 Conditions)****CONCATENATE vs CONCAT in Excel (2 Ideal Examples)****How to Concatenate Number and Text in Excel (6 Methods)****Concatenate Names in Excel (5 Easy Ways)**