Remove Quotes In Excel

Generally it is observed that we get some embedded quotes or quotation marks in our data specially if it is imported from some different source.

Removing quotes in excel one by one is a hectic task and we could remove those quotation marks by using excel formula.

Let’s see in the below example how we could remove the quotation mark from a string in excel.

We will see a simple formula using TRIM and SUBSTITUTE in excel to get the desired result.

Capture




Enter the formula below in cell B2, SUBSTITUTE will replace the quotation marks with blank and TRIM function will remove extra blanks that we will get after substitution.

=TRIM(SUBSTITUTE(A2,””””,””))

Capture

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply