How to Display Double Quotation Marks (“”) in Excel Formulas

スポンサーリンク
スポンサーリンク

How to Display Double Quotation Marks (“”) in Excel Formulas

When using Excel formulas to concatenate strings, you may need to display double quotation marks () as part of the text. However, since double quotation marks have a special role in formulas, directly inputting them will cause an error. To handle this, you need to use “” to treat them as text. This article explains how to do so in detail.

Basic Rule

In Excel, to display double quotation marks as text, use “”.
Example: Entering =”Hello “”World””” in a cell will display Hello “World”.

Example of Displaying Double Quotation Marks with the CONCAT Function

To include double quotation marks in a string using the CONCAT function, follow these steps:

Example 1: Concatenating Strings with Double Quotation Marks

Prepare the following data:

A B C
1 Hello World =CONCAT(A1, ” “””, B1, “”” “)

Use the following formula:

=CONCAT(A1, ” “””, B1, “”” “)

Result

The cell will display the following:

A B C
1 Hello World Hello “World”

Example of Displaying Double Quotation Marks with the TEXT Function

You can also handle double quotation marks using the TEXT function.

Example 2: Displaying Strings in a Specific Format

Use the following formula:

=TEXT(1234, “””USD”” #,##0″)

A B C
1 1234 =TEXT(A1, “””USD”” #,##0″)

Result

The cell will display the following:

A B C
1 1234 USD 1,234

Key Points

  • Remember to use “” when treating double quotation marks as text.
  • Combine spaces and symbols appropriately to ensure the content in cells remains easy to read.
  • If multiple instances of double quotation marks appear, verify your formula carefully through trial and error.

Conclusion

To display double quotation marks within Excel formulas, you need to use “”. Refer to the examples using the CONCAT and TEXT functions to streamline your work efficiently.