Remove Quotes In Excel

Check Also Extract Substring Between Parenthesis In Excel
Check Also Count Number Of Users Who Are Active In An Excel Workbook
Check Also VBA To Open Latest Excel Workbook
Check Also Print Cell Height And Cell Width Of A Cell In Excel
Check Also Delete Non Numeric Values From Numeric Field In Excel
Check Also Create Rows From Column In Excel
Check Also Sum Numbers Separated By Symbol In Excel
Check Also Sort Comma Separated Values Within A Cell In Excel

Home

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.

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.

Share The Knowledge

Admin

Random Posts

Excel Assign Row Number If Cell Is Not Blank
automatically assign row number if data is not blank in excel, assign row number to non blank data in excel, assign row number to all non blank values in excel

Share The Knowledge
Excel VBA To Delete Shape Whose Name Starts With Certain String
Delete shapes in excel if the name has certain string, delete shape in excel based on the names, excel delete shapes on the basis string in the name, excel delete shape looping through shape names

Share The Knowledge
Automatically Resize Comment Boxes In Excel
In this post we will see how we could resize multiple comment boxes to fit the contents in excel at […]

Share The Knowledge
Vlookup Each Comma Separated Value In One Cell In Excel
This post demonstrates how we could vlookup each comma separated value in one cell. To understand it further let’s refer […]

Share The Knowledge