Hi, Just want to seek help on how to remove the double quote on a certain column in a CSV file when converting it to a text file. In the CSV file, the values are separated by a comma and no double quotation mark but when the csv has been converted into a .txt file, it has now the double quotation mark.
Example:
In CSV, there are no quotation mark in column I
while when I convert it to this .txt file it looks like this
Can someone help me to remove the “” in the text file using VBA Macro.
Thank you so much.