Adding a quote for each string AND a bracket around the entire cell?

[michaelberk]

Hi there, I need each cell in a column formatted like: ["Offer1","Offer2","Offer3"]

Each cell is currently in the format of: Offer1, Offer 2, Offer 3

How can I add a bracket around the entire cell, and add quotes around each string, AND keep the comma between each string?

Every list is in one cell btw, not multiple cells.

[#2]

@michaelberk 

Let's say you have such values in A1 and down.

Enter the following formula in B1, then fill down:

="["""&SUBSTITUTE(A1,",",""",""")&"""]"