Remove Quotation Marks in Excel: Methods That Work

How-to basics · Updated November 20, 2026

To remove straight double quotation marks from text in Excel, use Find and Replace with " as the text to find and leave Replace with blank. To keep the original data unchanged, put =SUBSTITUTE(A2,CHAR(34),"") in another cell instead; it removes every straight double quote from the value in A2.

Choose the right method for your data

Use Find and Replace when you want to change the selected cells directly and are confident that every matching quotation mark should go. Use a formula when you want to preserve the source data, review the cleaned results, or repeat the cleanup as new rows arrive. Both methods remove quote characters that are actually part of the cell’s text.

Before changing a large range, check what the marks mean. A quote can be part of a sentence, a measurement, a code, or an imported text value. Removing every quote from a column of dialogue may be correct; removing the mark from a value such as 12" may erase the notation for inches. If some rows need different treatment, use a formula or clean only the relevant cells rather than replacing quotes throughout the entire worksheet.

What quotation marks in Excel can represent

Excel may show quotation marks for several different reasons, and they do not all call for the same fix. The most common case is that a cell contains ordinary text characters, such as She said "ready". A formula or Find and Replace can remove those characters. The straight double quote on a standard keyboard is character 34 in the ASCII character set.

Curly quotation marks are different characters: opening curly quotes and closing curly quotes are often used by word processors or copied text. They may look similar to straight quotes but are not removed by a search for a straight quote. There is also a separate CSV issue: quotation marks can act as text delimiters in a file. During a correct import, those delimiters usually control how fields are read rather than becoming part of the cell value.

Finally, a mark may come from a cell’s number format rather than its stored value. Custom number formats can include literal characters, so the worksheet may display a quote even though the cell’s underlying value does not contain one. In that case, changing the text with SUBSTITUTE will not remove the displayed mark; inspect the number format instead.

Remove quotes with Find and Replace

Find and Replace is the quickest way to remove straight quotes from existing values. In Excel for Microsoft 365 on Windows, select the range you want to clean, press Ctrl+H, enter one straight double quote in Find what, leave Replace with empty, and choose Replace All. You can also open it from Home > Find & Select > Replace.

  1. Select the target cells first if you do not want to affect the whole worksheet.
  2. Open Replace and enter " in Find what.
  3. Keep Replace with blank, then choose Replace All.
  4. Review Excel’s replacement count and inspect representative cells before saving.

On Excel for Mac, open the Replace command from the Edit or Find menu; menu labels can differ by release. Control+H is the usual Replace shortcut in Excel for Mac. Excel for the web also supports ordinary find-and-replace, though its dialog and available options may not match the Windows desktop version exactly.

Selection matters: if you intend to clean one column, select it before opening Replace and confirm the search scope in the dialog. Avoid running Replace All across cells containing formulas unless you mean to edit the formula text too. A quote character can be part of a formula’s syntax, and changing it may break the formula. When the target range mixes formulas and fixed text, a helper formula is usually safer.

Remove quotes with a formula

For a reversible cleanup, assume the original text is in A2 and enter this in B2:

=SUBSTITUTE(A2,CHAR(34),"")

For example, if A2 contains She said "ready", the result in B2 is She said ready. SUBSTITUTE replaces matching text, and CHAR(34) identifies the straight double-quote character. Because the optional instance number is omitted, the formula removes every matching quote in the cell, not just the first one.

Copy the formula down the helper column to process more rows. You can drag the fill handle or select the destination cells and use Ctrl+D on Windows to fill down. On Mac, the Fill Down shortcut is Control+D. Check the results before replacing the source: copy the cleaned cells, then use Paste Special > Values to place the results over the originals if you want permanent text rather than formulas. Keep a backup if the source is important, because replacing values is harder to reverse after closing the workbook.

The formula returns cleaned text for text input; it does not change the original cell. If A2 is blank, the result is blank. If you need to retain the quotes in some records, use an additional condition or clean only the rows that meet your rule instead of applying the same formula indiscriminately.

Remove curly quotes or only selected quotes

If copied text contains curly quotation marks, search for and remove those characters separately, or use a formula that handles both. With source text in A2, this formula removes the opening curly quote (Unicode 8220) and closing curly quote (Unicode 8221):

=SUBSTITUTE(SUBSTITUTE(A2,UNICHAR(8220),""),UNICHAR(8221),"")

For example, if A2 contains “Good morning” with curly marks, the result is Good morning. UNICHAR returns the character identified by its Unicode number. If the text may contain both straight and curly marks, nest another SUBSTITUTE to remove the straight quote as well, or run a separate replacement for that character. Check a few source cells first because visually similar marks can have different codes.

Sometimes the goal is to remove only the first straight quote, not all of them. With the source in A2, use =SUBSTITUTE(A2,CHAR(34),"",1). If A2 contains a"b"c, the result is ab"c: only the first matching character is removed. The final argument specifies which occurrence to replace. This is useful for controlled cleanup, but it is not a good choice when the requirement is to strip every quote.

When quotes come from a CSV import

CSV files often use quotes to keep a field containing commas together, for example a field like "Smith, Jordan". In a correctly parsed CSV import, the outer marks can function as text qualifiers; they are not necessarily part of the resulting cell value. Deleting characters after import without checking can therefore solve the wrong problem or remove legitimate quotation marks inside the data.

In Excel for Microsoft 365 on Windows, use Data > From Text/CSV to preview a file before loading it. Check the delimiter and the previewed columns. The import process interprets the file’s structure, including quoted fields, rather than treating every delimiter mark as ordinary text. If the preview shows unwanted marks inside the actual field values, first confirm whether they are truly part of the source data. Import controls and menu layouts can differ on Mac and in Excel for the web, so use the import options available in your version.

A related CSV convention is to represent a literal quote inside a quoted field by doubling it. For instance, a source field may encode a sentence with doubled quote characters so the file can distinguish content from the field boundary. A CSV-aware import can interpret that convention. Opening a CSV directly or using a different import setting may produce a different result, so it is worth checking the preview and comparing one known record with the source file before cleaning an entire dataset.

Common problems and safe cleanup checks

  • The quote remains after Find and Replace: check whether it is curly rather than straight, whether it is part of the number format, or whether the mark is in a different cell than expected.
  • The formula does not remove it: confirm that the formula refers to the correct source cell and that the character is not a curly quote or another look-alike symbol.
  • A formula appears instead of a result: make sure the cell is not formatted as Text, then re-enter the formula. Also check that formulas are being displayed rather than calculated.
  • Numbers or codes change unexpectedly: quotes may be meaningful notation, or the value may be stored as text. Inspect the original and cleaned values before replacing data.
  • Some rows should keep their quotes: do not use Replace All on the whole sheet. Select only the intended cells or use a helper formula and review exceptions.

In particular, do not confuse a double quote inside a cell with the apostrophe Excel may use to mark text entered with a leading apostrophe. The leading apostrophe is generally an input indicator and is not displayed as part of the cell’s value in the same way. Removing visible double quotes will not change that text-entry behavior.

For important workbooks, preserve the original column until the cleaned output has been checked. Compare a handful of ordinary rows, rows with multiple quotes, blank cells, and any records containing inches, dialogue, or embedded commas. If the cleaned values are right, paste them as values into a new column or over the source as needed. This makes it easier to spot accidental data loss than making a workbook-wide change without a review step.

Frequently Asked Questions

How do I remove all double quotes from a cell in Excel?

Use =SUBSTITUTE(A2,CHAR(34),"") when the text is in A2. It removes every straight double quote and leaves the source cell unchanged. Fill the formula down for other rows, then paste the results as values if you want to replace the original text.

Can I remove quotation marks from a whole column at once?

Yes. Select the column or intended range and use Ctrl+H on Windows to replace a straight quote with blank, or enter the SUBSTITUTE formula in a neighboring column and fill it down. Selecting a range first helps prevent changes to unrelated worksheet data.

Why does Find and Replace not find my quotation marks?

The character may be a curly quote rather than a straight quote, or it may come from formatting instead of the cell value. Try selecting a mark and checking its appearance, test the curly-quote formula, and inspect the cell’s number format if a formula does not change what is displayed.

Will removing quotes change numbers stored as text?

It can change the text characters, but it does not automatically convert the result into a number. After cleanup, check whether Excel treats the value as text or numeric data before using it in calculations, sorting, or lookups.

Should I remove quotation marks from a CSV file after importing?

Not automatically. Quotes may be CSV field delimiters that the import process already interprets, or they may be literal characters in the data. Preview the import and inspect the resulting cell value first; remove marks only when they remain in the value and are unwanted.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.