Dumping Excel file to txt file adding double quotes

I have an excel file that I am saving as a txt (tab delinmited) file for import into another system.  Everytime I save to txt, it is adding double quotes in front of every line in the txt file.  I can see them when I open in notepad.  How can I change the xlsx file it so that it doesn't do that?  Help, please!

Sample of the Excel data attached
Test.xlsx
timoteogaAsked:
Who is Participating?
 
Patrick MatthewsConnect With a Mentor Commented:
One of your columns has a comma in it.  By default, Excel will want to use doublequotes as a text qualifier because of that.

When I removed all commas via find/replace and then saved as a tab delimited txt file, I got no text qualifiers.
0
 
Ron MalmsteadInformation Services ManagerCommented:
The quotes are there to help distinguish the field data.
I'm not sure if there is a way to turn it off...but why not just do a find/replace in notepad to remove all the double quotes?
0
 
Ron MalmsteadInformation Services ManagerCommented:
Another thing you can do, is select all the data you want.... copy/paste into notepad and it will be Tab delimited by default, without quotes...
0
 
mmarisCommented:
In the following thread, the people resolved the issue with simple code:

Sub exportdata()
 Cells.Select
 Selection.Copy
 Shell "notepad.exe", vbNormalFocus
 SendKeys "^V"
 SendKeys "%fa"
 End Sub

http://www.ozgrid.com/forum/showthread.php?t=18333&page=1

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.