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

Get FREE Advanced Excel Exercises with Solutions!

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.


How to Add Double Quotes in Excel Concatenate: 5 Easy Ways

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.

5 Ways to Add Double Quotes in Excel Concatenate


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.

Using Ampersand (&) Operator to Add Double Quotes in Excel

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.

Using Ampersand (&) Operator to Add Double Quotes in Excel

  • 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


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)

Use of Ampersand (&) Operator and CHAR Function to Add Double Quotes in Excel

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.

Use of Ampersand (&) Operator and CHAR Function to Add Double Quotes in Excel

Read More: How to Concatenate Single Quotes in Excel


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,"""")

Using CONCATENATE Function to Add Double Quotes

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.

Using CONCATENATE Function to Add Double Quotes

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

Applying CONCATENATE and CHAR Functions to Add Double Quotes in Excel Concatenate

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.

Applying CONCATENATE and CHAR Functions to Add Double Quotes in Excel Concatenate


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.

Use of Format Cell Feature to Add Double Quotes in Excel

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.

Use of Format Cell Feature to Add Double Quotes in Excel

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

Use of Format Cell Feature to Add Double Quotes in Excel


Practice Section

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

Practice Section


Download Practice Workbook


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.


Related Articles


<< Go Back to Quotes in ExcelConcatenate Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Arin Islam
Arin Islam

Anowara Islam Arin, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Arin exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Besides, she is also interested in Advanced Excel,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo