microsoft.public.excel.programming

Bob Flanagan

12/20/2006 1:19:00 PM

It sounds like you are saving it as a CSV file. Doing that way makes it
comma delimited. As a cell entry contains a comma, the double quotes
prevent it from being treated as two separate values. Try saving it as a
TXT or a PRN file.

Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, cell 302-584-1771
http://www.a...
Productivity add-ins and downloadable books on VB macros for Excel

<christophe.leroquais@gmail.com> wrote in message
news:1166620411.186255.272530@a3g2000cwd.googlegroups.com...
> Hi,
>
> i'm having an issue trying to save an excel file containing cells with
> multiple values separated by commas.
>
> for example, i have in a cell of the excel file:
>
> myField1,myField2
>
>
> I want to save it in a text file format and i'm not happy because the
> resulting txt file is:
>
> "myField1,myField2"
>
> I do not want these "" in the text file. Is there a way to cope with
> that?
>
> Thank yiu
>