File Convert With commas to txt format
 

I have an Excel file that contains over 10,000 records, some of whose values
contain commas. When I convert the table to a txt format the field values
tha contain commas are off-set with double quotes. I DON'T WANT the double
quotes, but I DO wish to retain the commas. What do I do differently? MS
Help warns about the double quotes but does nothing to "educate me around"
the dilema. I would appreciate any help.

Jay

File Convert With commas to txt format
 

Select your range
Go to menu select Edit Replace Find What:"" Replace With:, Replace All

"jayceejay" wrote:

I have an Excel file that contains over 10,000 records, some of whose values
contain commas. When I convert the table to a txt format the field values
tha contain commas are off-set with double quotes. I DON'T WANT the double
quotes, but I DO wish to retain the commas. What do I do differently? MS
Help warns about the double quotes but does nothing to "educate me around"
the dilema. I would appreciate any help.

Jay

File Convert With commas to txt format
 

Jay

You may find saving the file down as a .prn (in the SaveAs menu options
as Formatted Text (Space Delimited) useful - you'll have to change the
extension to .txt afterwards (eh thru Windows Explorer or maybe via
VBA) but it shouldn't surround your elements with double quotes.

Hope this helps!

Richard


jayceejay wrote:
I have an Excel file that contains over 10,000 records, some of whose values
contain commas. When I convert the table to a txt format the field values
tha contain commas are off-set with double quotes. I DON'T WANT the double
quotes, but I DO wish to retain the commas. What do I do differently? MS
Help warns about the double quotes but does nothing to "educate me around"
the dilema. I would appreciate any help.

Jay

File Convert With commas to txt format
 

Earl Kiosterud's free TEXTWRITE add-in should(will) do what you want.

http://www.smokeylake.com/excel/text_write_program.htm

Allows you to select the delimiter of choice.


Gord Dibben MS Excel MVP

On Thu, 14 Dec 2006 09:56:00 -0800, jayceejay
wrote:

I have an Excel file that contains over 10,000 records, some of whose values
contain commas. When I convert the table to a txt format the field values
tha contain commas are off-set with double quotes. I DON'T WANT the double
quotes, but I DO wish to retain the commas. What do I do differently? MS
Help warns about the double quotes but does nothing to "educate me around"
the dilema. I would appreciate any help.

Jay

Gord Dibben MS Excel MVP