How to Add Double Quotes in Excel (5 Smart Ways)

Get FREE Advanced Excel Exercises with Solutions!

We like to highlight the important part of our writings. We even like to highlight it with double quotes too. In terms of working in Excel, double quotes can be a very useful thing to highlight a thing or to show a quotation. In this article, I am going to elaborate 5 smart ways to add double quotes in Excel. I hope it may bring some good to Excel users.

For more clarification, I am going to explain the procedures with a dataset containing Quotes and Authors columns.

How to Add Double Quotes in Excel

1. Using Double Quotes and Ampersand Operator to Add Double Quotes in Excel

Double quotes and ampersand operators can be very useful tools in a formula to add double quotes.

Steps:

  • Select a cell for having the cell values with double quotes. Here, I have selected cell D5 for the output.
  • Input the following formula in that cell.
=""""&B5&""""&" quoted by  "&""""&C5&""""

Here, the values in cells B5 and C5 will be in double quotes with the additional portion in the formula.

  • Press ENTER to have the cell values in double quotes.

How to Add Double Quotes in Excel

  • Finally, use Fill Handle to AutoFill the rests.

Thus, we can add double quotes quite easily.

Read More: How to Concatenate Single Quotes in Excel


2. Applying Custom Command of Format Cells to Add Double Quotes

We can add double quotes by applying the Custom command of Format Cells.

Steps:

  • Select the cells where you want to add double quotation. I have selected cells B5:C9 for that purpose.
  • Then, go to the Home tab.
  • Click on the extended Number Format button.

How to Add Double Quotes in Excel

  • From there, pick the More Number Formats… option.

A Format Cells wizard will appear.

  • Go to Custom from Category.
  • Then, employ the double quotation command “@” from the Type option.
  • Finally, press OK to add double quotes.

How to Add Double Quotes in Excel

Thus, simply we can add double quotes in Excel.


Similar Readings


3. Adding Double Quotes by Combining Excel CONCATENATE and CHAR Functions

The CONCATENATE function adds the different values in one cell. We can use this function with the CHAR function to add double quotes.

Steps:

  • Firstly, select a cell for having the result. Here, I have selected cell D5 for the output.
  • Apply the following formula in that cell.
=CONCATENATE(CHAR(34),B5,CHAR(34)," quoted by ",CHAR(34),C5,CHAR(34))

Here, the CONCATENATE function adds all the commands inside it in one cell.

How to Add Double Quotes in Excel

  • Next, press the ENTER button.

  • AutoFill the remaining cells.

How to Add Double Quotes in Excel

Read More: How to Add Double Quotes and Comma in Excel with CONCATENATE


4. Combining CHAR Function and Ampersand Operator to Add Double Quotes in Excel

The CHAR function combined with the Ampersand operator could be a very simple way to add double quotes. The CHAR function returns a special character for different specified numbers.

Steps:

  • Firstly, select a cell for having the cell values with double quotes. Here, I have selected cell D5 for the output.
  • Next, input the following formula in that cell.
=CHAR(34)&B5&CHAR(34)&" quoted by  "&CHAR(34)&C5&CHAR(34)

Here, due to the addition of the CHAR function, the values in cells B5 and C5 will be in double quotes with the additional portion in the formula.

  • Hit ENTER to have the desired output.

How to Add Double Quotes in Excel

  • AutoFill the rests.


5. Using the CONCATENATE Function to Add Double Quotes

We can even use the CONCATENATE Function alone to add double quotes.

Steps:

  • Pick a cell for having the result. Here, I have selected cell D5 for the output.
  • Next, apply the following formula in that cell.
=CONCATENATE("""",B9,""""," quoted by  ","""",C9,"""")

Here, the CONCATENATE function adds all the commands inside it in one cell.

How to Add Double Quotes in Excel

  • Press ENTER.

  • Use Fill Handle to AutoFill the rests.

How to Add Double Quotes in Excel


Download Practice Workbook


Conclusion

That’s all for the article. In this article, I have tried to elaborate on 5 smart ways to add double quotes in Excel. It will be a matter of great pleasure for me if this article could help any Excel user even a little. For any further queries, comment below.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Naimul Hasan Arif
Naimul Hasan Arif

Hello everyone, I am Naimul Hasan Arif, graduated from Bangladesh University of Engineering and Technology (BUET). I am working as an Excel and VBA Content Developer. I try to remain dedicated to my duties and give my best with my skills & knowledge.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo