0

I want to add the csv data in double quotes and want comma at the end. Any idea on how we can achieve that? Would like to have solution which I can run in Microsoft excel or in Google colab. Apologies if the question is not in correct format. English is not my first language and I am a new programmer.

Current data-

enter image description here

Expected output-

enter image description here

Mike Carell
  • 45
  • 4
  • There already thread on this [link](https://stackoverflow.com/questions/4617935/is-there-a-way-to-include-commas-in-csv-columns-without-breaking-the-formatting) – sumati patri Jun 21 '23 at 18:34

1 Answers1

0

In Excel, I would just do this:

=""""&A1&","""

But I have the comma misplaced:

=""""&A1&""","

Like so:

enter image description here

The you can copy & paste.special values.

Solar Mike
  • 7,156
  • 4
  • 17
  • 32