How to Remove Quote Marks Around Text From Cell in Excel?

Excel is a strong tool for organising and analysing data, but occasionally you may discover that some cells have quote marks (single or double) surrounding the text when you import or copy data into your spreadsheet. These extra quotes may be unneeded and interfere with computations or data manipulation. The easiest way to finish the process is by using the Find and Replace tool.

This step-by-step tutorial will show you how to eliminate those quote marks from cells using a variety of techniques. We can handle quoted text in any number of cells, including an entire column. You'll be able to easily clean up your data and work with cells that are free of quote marks by the end of this course. Let's get going and organise your Excel data so that it is prepared for analysis.

Remove Quote Marks Around Text From Cell

Here, we can complete the task using the find and select functions. So let us see a simple process to know how you can remove quote marks around text in a cell in Excel.

Step 1

Consider an Excel sheet where you have a list of strings with quote marks, similar to the below image.

First, click Ctrl + H to open the Find and Replace.

Step 2

Then click on Replace, and in the text box named Find what, enter " and click Ok to complete the task.

Replace > Find what > OK.

Then you will see that the quote marks will be removed. This is how you can remove quote marks around text in Excel.


In this tutorial, we have used a simple process to learn how you can remove quote marks around text in cells in Excel to highlight a particular set of data.

Updated on: 08-Sep-2023


Kickstart Your Career

Get certified by completing the course

Get Started