There are some data in Excel Cells with Quotation Marks. e.g. Team "A". When I need to import that data into the database system, double quote is not allowed, so I needed to remove it. The problem is in the formula of Excel, double quote is also used to identify a particular string. With some trail and error, I finally managed to do it using the Excel function
substitute(). The syntax is as followed.
substitute(<>, """", "")
I hope the little trick above can save you some times
No comments:
Post a Comment