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.
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,””””,””))
Hope this helped.
