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

  • Thread starter Thread starter jaffar Sadiq
  • Start date Start date
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
 
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.
 
Back
Top