Maybe you could build your own formula that concatenates the values in each cell
in the row:

I put
asdf (in A1)
qwer (in B1)
w.c (in C1)

I put this in D1:
=""""&A1&""","""&B1&""","""&C1

and it evaluated to:
"asdf","qwer","w.c

Then I could drag that formula down the column.

Select the column, copy it, paste it into notepad and save it as my .csv file.

If you want to build a macro, you could have complete control over each field.

Some sample code to get you started:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

William DeLeo wrote:

Is there no one that can offer suggestions? Macro or formula?

Thanks

--
William DeLeo
------------------------------------------------------------------------
William DeLeo's Profile: http://www.excelforum.com/member.php...fo&userid=1256
View this thread: http://www.excelforum.com/showthread...hreadid=529335

--

Dave Peterson