Arin Islam
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.
Download Practice Workbook
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.
Read More: How to Add Single Quotes and Comma in Excel Formula (4 Ways)
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.
Follow the steps given below to do it on your own.
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.
Read More: How to Concatenate Single Quotes in Excel (5 Easy Ways)
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.
Read More: How to Add Double Quotes and Comma in Excel with CONCATENATE
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!
