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.