How to Delete Quotes in Excel

Evan Gower September 20, 2019

If you work with Excel, you might have noticed that the data in some files comes with quotation marks. That means that the file was created using one of many Excel formulas. Those formulas can help you crunch a lot of data quickly. The only downside is that the quotation marks remain.

However, you can remove the quotation marks at any time with a few clicks. Stay with us, and we will explain how to remove quotation marks from your Excel files.

Remove Quotes Using the Find and Replace Feature

The easiest way of removing any symbol, including the quotation marks, from your Excel file is using the “Find and Replace” function. Here is what you have to do:

Open the file and select all columns or rows from which you want to remove the quotes.
Open the “Find and Replace” function by holding Ctrl + F on your keyboard. You can find the function manually by navigating to “Find & Select,” then “Find” in your home bar.
Select the function and a dialog box will appear. Select the “Replace” tab and type a quotation mark into the “Find what” field.
Click the “Replace All” button if you want to delete all quotation marks. Leave the “Replace with” field blank.
Hit “OK” and Excel will tell you how many symbols it removed from the file.

This method is very easy and straightforward. However, Excel comes with many advanced features and commands that are not so easy to master. If you don’t have the time to learn formulas, you should try the Excel Kutools.

Removing Quotes Using Kutools

Excel is easy to get into, but hard to master. There are many formulas you can learn that allow you to get a lot of work done quickly. Those formulas can be hard to remember and making just one little mistake could have a negative impact on your file.

Kutools is an Excel add-on that allows you to use over 300 advanced features without learning the commands. You just need to click on the command you want and Kutools will do things for you. It’s the ideal add-on for people that have to work on large Excel sheets and don’t have the time to learn complex formulas and commands. Here is how you can use Kutools to remove quotation marks with just a few clicks:

Download and install Kutools.
Launch Excel and open the file you’d like to remove the quotation marks from.
Select the columns and rows you want to remove the quotes from and click on “Kutools” on top of the worksheet.
Select “Text,” and then click “Remove Characters.”
When the dialog box opens, tick the “Custom” box and enter a quote in the empty field. Hit “OK.”

Adding Quotes to Your Excel File

Removing quotes is one thing but, sometimes, you will have to add them to certain files. You can add them manually, but that will take a long time if you’re working in large worksheets. Luckily, the basic command that allows you to add quotation marks to any field on your worksheet is quite simple. Here is how you do that:

Select the cells where you want to add the quotes.
Right click then choose “Format Cells,” and finally, “Custom.”
Copy and paste the following command in the text box that appears: \”@\”.
Hit “OK.”

Don’t Do Things by Hand

Of course, you can add symbols to every cell individually, but that can take forever when you have to work through thousands of cells. The process can be very tedious, and you might miss some cells in the process.

If you don’t have the time to learn the formulas, you should get Kutools. The tool is free for two months once you register on the official website.

Finish Your Work in Minutes

No matter how complicated it may seem, Excel is a handy program designed to help bookkeepers and everyone else working with a lot of data. If you don’t have the time to learn all of the features and commands, download Kutools, and get the same results hassle-free.

How do you remove the quotation marks from large Excel files? Do you use Excel’s native solution or do you use a third-party app? Share your thoughts with us in the comments below.