Quotations being added when converting to .txt file

[Rohohoho]

Hello, I tried the suggestions in a similar thread and had not have any luck.

I created a .xlxs file and need to save as a text tab delimited file (.txt) to upload to a website.
all my data is saved as text.
It all look great, but when I convert, about every third line gets some extra quotation marks in it and the formatting goes all skewed.
I tried save as txt, and also tried the text import wizard.

35	1	MTN-1801-SS-EAR	Geo Mountain	active		Earrings	Sterling silver															70			3
42.5	1	MTN-1801-RG-EAR	Geo Mountain	active		Earrings		plated 18k rose gold													85			2
42.5	1	MTN-1801-YG-EAR	Geo Mountain	active		Earrings			Plated 18k Yellow Gold												85			1
32.5	1	MTN-1802-SS-EAR	Coastal Mountains Circle	active		Earrings	Sterling silver															65			2

when I convert to text, I get this:

can anyone help me please?
Thank you in advance

 

[kweaver]

If you post using XL2BB anyone trying to help you won't have to try to replicate and/or retype the data.

 

[kweaver]

When I saved what looks like your sheet that you post above, I get a text file that looks like this:

 

[Rohohoho]

If you post using XL2BB anyone trying to help you won't have to try to replicate and/or retype the data.

Thank you, I will look into how to use that feature.

 

[Rohohoho]

If you post using XL2BB anyone trying to help you won't have to try to replicate and/or retype the data.

Thank you. I will look into how to install this add on feature. this is new to me.

 

[Rohohoho]

When I saved what looks like your sheet that you post above, I get a text file that looks like this:

View attachment 36255

hmm, looks normal. is that comma delimited? I still can't figure out why I am getting the quotations in the tab delimited test file. i will try and get that add on loaded so I can improve my post and people can see my actual data. thank you

 

[kweaver]

Yes, it's comma delimited. Maybe the issue is with the macro you're using to save the sheet as a text file.