Excel Guides

Getting Rid of Extra Quote Marks in Exported Text Files in Excel

If you’re working with text files in Excel, you may have noticed that extra quote marks sometimes get added to your data when you export it. This can be frustrating, especially if you’re working with a lot of data. Luckily, there are a few ways to get rid of these extra quote marks.

One way to remove the extra quote marks is to use the “Text to Columns” feature. To do this, select the column of data that has the extra quote marks, then go to the “Data” tab and click “Text to Columns.” In the “Text to Columns” wizard, select “Delimited” and click “Next.” Then, uncheck the “Tab” option and check the “Other” option. In the box next to “Other,” type in a character that is not used in your data, such as a comma or semicolon. Click “Finish,” and your data will be split into multiple columns at the specified character. You can then delete the column that contains the extra quote marks.

Another way to remove extra quote marks is to use a formula. For this method, you will need to know which character is being used as a delimiter in your text file (usually a comma or semicolon). Let’s say the delimiter is a comma. To remove the extra quote marks, you can use the following formula:

=SUBSTITUTE(A1,"""","")

This formula will replace all double quotes in cell A1 with nothing (i.e., it will remove them). You can then copy and paste this formula into all other cells in your column.

You can also use a macro to remove extra quote marks. For this method, you will need to know how to create and edit macros in Excel. The following macro will remove all double quotes from a selected range of cells:

Sub RemoveQuotes()
    Dim cell As Range

    For Each cell In Selection
        cell.Value = Replace(cell.Value, Chr(34), "")
    Next cell
End Sub

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.