How to convert CSV to txt File without the double quotation of values separated by comma

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
image

while when I convert it to this .txt file it looks like this
image

Can someone help me to remove the “” in the text file using VBA Macro.
Thank you so much.

Hi @Greggy ,

Could you let us know what is the method you have used to convert to Text file ?