CSV exporting problem (quotes)

**Sebolains** · 05-03-2010, 06:58 PM

Hi everyone! I'm currently having some problems trying to export my excel file to a csv. Here's my problem:

I would like my file output to look something like this:
"1","2","some text without commas","some text, with, commas","B"
etc.

The problem I have is that I can't get Excel 2007 to write the quotes around EVERY field. It is currently just writing the quotes around those fields with a comma in it. Is there a way around this?

I really appreciate any help you can provide me with! THANKS A MILLION!

**martindwilson** · 05-03-2010, 07:31 PM

one way
copy paste special unformatted text the whole thing into word
find ^t replace with "," (including quotes)
then find ^p replace with "," (including quotes)
tidy up the begining (just add ") and delete any odd "," at end
save as text
before

123 some text comma,text b
124 some text comma,text c
125 some text comma,text d

after

“123”, “some text”, “comma,text”, “b”, “124”, “some text”, “comma,text”, “c”, “125”, “some text”, “comma,text”, “d”