Converting from Excel to text w/o quotes (" ")

J

jaffar Sadiq

When converting from excel to tab delimited text format,
The text file automatically padded with open & end quotes
( " ") if any of the cell has a comma (,). Is there any
way to convert to text w/o the quotes i.e. to reflect
exactly what it is in excel? Apprecaite your Advice.

Thank you
 
G

gschimek

The quotes come from having characters in the cells that could be
misinterpreted (i.e. commas, slashes, ?'s). There's a "great"
knowledge base article on microsoft's website that I've never gotten to
work properly.

Instead, I used a program called text-write at:

http://tinyurl.com/nxmb

It worked great for me. Good luck.
 
Top