View Single Post
  #2   Report Post  
Bernie Deitrick
 
Posts: n/a
Default Exporting to text, cells with comma's are placed in quotes. -Bad

Pallid,

Use a macro to create the output. The quotes were put there to prevent the string being broken into
three cells, based on the commas.

Visit

http://www.cpearson.com/excel/imptext.htm

for an example of how to export to a text file.

HTH,
Bernie
MS Excel MVP


"pallid" wrote in message
...
I am exporting Excel worksheets to text files. Currently data like this:
RGB(0, 0, 255)
is placed in quotes when I export. I need to prevent the insertion of the
quotations. How do I do this?