View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
V.R.
 
Posts: n/a
Default How to save text as CSV which also contains commas?

Thanks David.
Opening the file in notepad looks fine.
But, what about if I want to see the data as an excel sheet. Extra commas in
a field shows me extra column. Isn't there a way to avoid this?


"David Biddulph" wrote:

"V.R." wrote in message
...
How can I save a data file in CSV format when one of the fields contains
commas?


By default, Excel will include double quotes round the contents of such
field, and when importing the csv file it will treat the double quotes as
text delimiters. Save it as CSV, then look at the CSV file with something
like Notepad.
--
David Biddulph