How to Add Double Quotes in an Excel Formula for Text

Formulas & functions · Updated November 18, 2026

To show double quotation marks in text produced by an Excel formula, type each quote mark twice inside the formula’s text string. For example, with no cell references needed, enter ="She said ""Hello""" in a cell; the result is She said “Hello”. Excel uses ordinary double quotes to mark the start and end of text in a formula, so doubling a quote inside that text tells Excel to display it instead of treating it as formula punctuation.

This guide covers both adding visible quote marks to a formula’s result and using quotes correctly around text values in a formula. The examples apply to Microsoft Excel for Microsoft 365 on Windows. The same formula syntax generally works in Excel for Mac and Excel for the web.

What You’ll Need

  • Excel for Microsoft 365, Excel for Mac, or Excel for the web.
  • A blank cell for entering or testing a formula.
  • If you want a formula to wrap existing text in quotes, a cell containing that text, such as A2.

You do not need to change an Excel setting or enable a special feature. A double quote is entered from your keyboard; on many US keyboard layouts, press Shift and the apostrophe key. Keyboard layouts differ, so use the key that produces a straight double quote ("), not curly quotation marks (“ ”).

Step-by-Step

  1. Decide where the quote marks should appear. There are two common goals: include quotation marks around text returned by a formula, or put quotation marks around text inside a formula so Excel recognizes it as a text value. These are related but different. In =A2&"", for example, Excel sees a text string containing no characters; it does not add visible quote marks around A2. For visible quotation marks, the formula must include a literal quote character.

  2. Start with a simple text formula. Select a blank cell, type an equals sign, and enter text inside a pair of double quotes. With no cell references needed, enter ="Hello". Press Enter. The cell displays Hello. The first and last quote marks identify the text string to Excel; they are not displayed as part of the result.

  3. Double the quote marks you want Excel to display. To put quotation marks around a word, place two double-quote characters where each visible quote should go, while keeping the text string’s opening and closing quotes. With no cell references needed, enter ="""Hello""". The result is “Hello”. It can help to count the marks: three appear together before Hello and three after it. In each group, two marks create one visible quote, while the remaining mark starts or ends the text string.

  4. Use doubled quotes for quoted speech or a phrase. Put the text and doubled quote marks in the same string. With no cell references needed, enter ="She said ""Hello""". Excel displays She said “Hello”. This is useful for labels, instructions, sample dialogue, or a formula-generated sentence. The quote marks around Hello are doubled in the formula, but each pair becomes one quote in the result.

  5. Wrap text from a cell in quote marks. Use the ampersand (&) to join a quote character, a cell reference, and another quote character. Assume A2 contains the text Excel. Enter =CHAR(34)&A2&CHAR(34). The result is “Excel”. CHAR(34) returns the character whose code is 34, a straight double quote. This method is often easier to read than counting several quote marks in a long formula, and it works when the cell’s text changes.

  6. Check the formula and confirm the displayed result. After pressing Enter, look at the cell to see the output and the formula bar to see the formula itself. The formula bar shows the doubled quote marks used in the formula; the cell shows the resulting single quote marks. If Excel displays an error or the formula as plain text, check that the formula begins with =, that its string boundaries are balanced, and that the cell is not formatted as Text.

  7. Apply the same pattern to a condition or a longer formula. Quotes around a text value used for comparison are formula syntax, not visible output. Assume A2 contains Paid. Enter =IF(A2="Paid","Ready","Pending"). The result is Ready because A2 matches Paid. Here, the quotes tell Excel that Paid, Ready, and Pending are text values. To display quote marks in a returned phrase, double the marks within the relevant text string, just as in the earlier examples.

Excel formulas use commas between function arguments in the examples above. If your regional settings use semicolons as argument separators, replace those commas where required by your Excel setup. This does not change how double quotes work inside text strings.

Common Mistakes

  • Using only one quote for a visible quote. A single quote mark inside a text string can be read as the end of that string, leaving the rest of the formula invalid. Double the mark you want displayed. For example, use ="""Hello""", not a formula with only one extra quote on either side.
  • Confusing formula delimiters with output characters. The outside quotes in ="Hello" tell Excel that Hello is text. They do not appear in the cell. Add doubled quote marks inside the string when you want the result to include quote characters.
  • Leaving out a quote at the end. Excel needs a closing quote for each text string. When the formula contains literal quote marks, several quotes may sit together, making one easy to miss. Compare the formula carefully with a working example and check both the beginning and end of each string.
  • Typing curly quotation marks. Curly quotes copied from formatted text may not behave as Excel’s formula delimiters. Type straight double quotes directly in the formula bar or cell. Curly marks can also appear as ordinary characters when you intended them to be formula syntax.
  • Expecting quotation marks to change a number into text in every context. Quotes make text inside a formula; they do not automatically format a numeric cell or alter its underlying value. If you need a number displayed with a particular format, use a number format or a suitable formula, depending on the goal.

Tips

  • Build the formula in small pieces. First confirm that the text or cell reference returns correctly. Then add one pair of literal quotation marks and check the result. This makes misplaced marks easier to locate than editing a long formula all at once.
  • Use CHAR(34) when repeated quotes become hard to count. It clearly represents a straight double quote and is convenient when you concatenate a changing value from a cell. Use doubled quote marks when the formula is short and you want the text to stay readable in one string.
  • Keep text values inside straight double quotes. Excel formula text is enclosed in double quotes. A single apostrophe is not a substitute, even if the text contains spaces. For a word such as Don’t, the apostrophe can simply stay inside the double-quoted string.
  • Test the output with a simple example. If A2 contains the word Report, a wrapping formula should display “Report”. Once the result is right, use the same pattern with your actual cell reference or longer sentence.
  • Remember that formulas and results look different. A formula can contain doubled quote marks while the displayed result contains only one quote at each position. This is expected, not a sign that Excel removed characters accidentally.

Troubleshooting

Excel reports that there is a problem with the formula. Check for a missing opening or closing quote, an extra ampersand, or a quote mark that was typed as a curly character. For a standalone result containing the word Hello in quotation marks, compare your entry with ="""Hello""". Retype the marks directly if you pasted the formula from a formatted document.

The cell shows the formula instead of its result. Confirm that the first character is an equals sign and that the cell is not set to Text. If it is formatted as Text, change the format to General using Home > Number Format > General, then edit the cell and press Enter again. Merely changing the format may not make an existing text entry calculate until you re-enter it.

The cell shows a formula error after adding a reference. Check that the reference is valid and that each part is joined with an ampersand when you are combining text. For example, the quote character, cell reference, and ending quote character in the wrapping example are joined as three parts. In function formulas, also check your regional list separator; some settings require semicolons rather than commas between arguments.

The quote marks appear in the formula bar but not where expected in the cell. That may be normal: formula syntax marks are not part of the result. If you need a visible mark, make sure the formula includes an escaped quote pair inside the text string or uses CHAR(34). Inspect the actual output rather than counting the formula’s syntax marks.

The result has two visible quote marks instead of one. You may have added two literal quote characters rather than using a doubled pair to represent one. In a text string, each pair of consecutive quote marks represents one visible quote. Reduce the number of encoded pairs if the output has too many marks.

Excel still will not accept the entry. Try entering the short standalone example in a new blank cell. If it works, add your original formula’s text and references back piece by piece. If it does not, check the keyboard layout, confirm that the cell is not being treated as text, and verify that the quotes are straight. Excel for Mac and Excel for the web use the same basic quote rules, although menus and keyboard layouts can differ.

Frequently Asked Questions

How do I put double quotes around a cell value?
Join a quote character, the cell reference, and another quote character. If A2 contains Excel, =CHAR(34)&A2&CHAR(34) returns “Excel”. You can also use doubled quote marks in a concatenated text formula.

Why do I need to type two double quotes in an Excel formula?
Inside a text string, two consecutive quote marks tell Excel to produce one literal quote character. A single quote normally marks where the text string ends, so doubling it distinguishes a displayed quote from formula syntax.

How can I make a formula return just one double quote?
With no cell references needed, enter ="""". The result is one straight double quote. The four marks in the formula include the text string’s delimiters and the doubled mark that represents the visible character.

Do I use single or double quotes for text in an Excel formula?
Use straight double quotes to enclose text values in formulas, such as ="Open". An apostrophe can appear within the text, as in a name or contraction, but it does not replace the double quotes that define the string.

Do these quote rules work in Excel for Mac and Excel for the web?
Yes. The rules for enclosing text and doubling a literal quote are the same in current Excel for Windows, Mac, and the web. The keyboard key that types a straight quote can vary by layout, and regional settings may change the separator used between function arguments.

Can I use double quotes in a formula without displaying them?
Yes. When quotes enclose a text value such as "Paid" inside an IF formula, they tell Excel how to interpret the text. Those delimiting marks are not included in the returned result unless you encode literal quote characters separately.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.