Exporting with Commas and not Tabs

[Jeff]

Hello,

When I save/export my Excel database into a text file
(Notepad) so I can do a mailing, the columns are
encapsulated by quotes (which is good) but the fields are
separated by TABS...

I need COMMAS to separate the fields.

How can I save/export my database as a text file and have
the field separated by COMMAS and not TABS?

Thank You Very Much!

 

[Richard Choate]

If you are using the data for a mailing, why don't you just leave it in
Excel? Otherwise, you can just save the file as a .CSV file. Drop open the
file types box and choose comma delimited from the choices.
Richard Choate


Hello,

When I save/export my Excel database into a text file
(Notepad) so I can do a mailing, the columns are
encapsulated by quotes (which is good) but the fields are
separated by TABS...

I need COMMAS to separate the fields.

How can I save/export my database as a text file and have
the field separated by COMMAS and not TABS?

Thank You Very Much!

 

[Gord Dibben]

Jeff

In the "Save As Type" dialog box, scroll down to CSV(Comma Delimited)

Gord Dibben Excel MVP - XL97 SR2 & XL2002

 

[Dave Peterson]

If you're using word to create your mailing labels(??), you may want to read
these:

http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge/index.html

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.