# How to Add Double Quotes in Excel Concatenate (5 Easy Ways)

Looking for ways to know how to add double quotes in Excel concatenate? Then, this is the right place for you. Here, you will find 5 different ways to add double quotes in Excel concatenate.

## 5 Ways to Add Double Quotes in Excel Concatenate

Here, we have a dataset containing the First Name, Last Name, and Age of some people. Now, we will show you how to add double quotes in Excel concatenate using this dataset. ### 1. Using Ampersand (&) Operator to Add Double Quotes in Excel

In the first method, we will show you how to add double quotes in Excel concatenate using the Ampersand (&) operator. Here, we will concatenate the values of Column B and Column C and add double quotes. Go through the steps given below to do it on your own.

Steps:

• In the beginning, select Cell D5.
• Then, insert the following formula.
`=""""&B5&" "&C5&""""` Here, we added a single quote, Cell B5 and C5, and again a single quote in the formula using the Ampersand (&) operator.

• Now, press ENTER.
• Then, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells. • Finally, you will get the full Names with Double Quotes using the Ampersand (&) operator. ### 2. Use of Ampersand (&) Operator and CHAR Function to Add Double Quotes in Excel

Now, we will show you how to add double quotes in Excel concatenate using the Ampersand (&) operator and the CHAR function. The CHAR function is used to get a specific value in return for a valid number. Here, we will concatenate the values of Column B and Column C and add double quotes.

Steps:

• Firstly, select Cell D5.
• Then, insert the following formula.
`=CHAR(34)&B5&" "&C5&CHAR(34)` Here, we used the CHAR function and inserted 34 as a number that will return a single quote. Then, we added this function twice in the beginning and at the end with Cell B5 and C5 in the formula using the Ampersand (&) operator.

• After that, press ENTER.
• Next, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells. • Finally, you will get the value of Names with Double Quotes using the Ampersand (&) operator and CHAR function. ### 3. Using CONCATENATE Function to Add Double Quotes

Next, we will add double quotes in Excel by using the CONCATENATE function. The CONCATENATE function is mainly used for adding text values in Excel. Here, we will show you how to use this function to add double quotes in Excel.

Steps:

• In the beginning, select Cell D5.
• Then, insert the following formula.
`=CONCATENATE("""",B5," ",C5,"""")` Here, we added double quotes, Cell B5, Cell C5, and a space between them using the CONCATENATE function.

• After that, press ENTER.
• Then, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells. • Finally, you will get the value of Names with Double Quotes using the CONCATENATE function. ### 4. Applying CONCATENATE and CHAR Functions to Add Double Quotes in Excel

We can also use both the CONCATENATE and CHAR functions to add double quotes in Excel. Go through the steps given below to do it on your own.

Steps:

• Firstly, select Cell D5.
• Then, insert the following formula.
`=CONCATENATE(CHAR(34),B5," ",C5,CHAR(34))` Here, we added double quotes, Cell B5, Cell C5 and a space between them using the CONCATENATE function. The double quotes are added by using the CHAR function.

• After that, press ENTER.
• Next, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells. • Finally, you will get the value of Names with Double Quotes using both CONCATENATE and CHAR functions. ### 5. Use of Format Cell Feature to Add Double Quotes in Excel

In the final method, we will show you how we can use Format Cell Feature to add double quotes in Excel. Here, we have a dataset containing the First Name and Last Name of some people. Now, we will add double quotes with these text values using the Format Cell Feature. Follow the steps given below to do it on your own dataset.

Steps:

• Firstly, select Cell range B5:C11 and Right-click. • Then, select Format Cells. • Now, the Format Cells box will open.
• After that, go to the Custom option.
• Then, type \”@\” as a format.
• Next, press OK. • Finally, you will get all the values of First Name and Last Name with double quotes. ## Practice Section

In this section, we are giving you the dataset to practice on your own and learn to use these methods. ## Conclusion

So, in this article, you will find detailed steps to add double quotes in Excel concatenate. Use any of these ways to accomplish the result in this regard. Hope you find this article helpful and informative. Feel free to comment if something seems difficult to understand. Let us know any other approaches which we might have missed here. And, visit ExcelDemy for many more articles like this. Thank you!

## Related Articles #### Arin Islam

Hello, I'm Arin. I graduated from Khulna University of Engineering and Technology (KUET) from the Department of Civil Engineering. I am passionate about learning new things and increasing my data analysis knowledge as well as critical thinking. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

We will be happy to hear your thoughts  5 Excel Hacks You Never Knew  