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

Occasional Visitor

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.

1 Reply

@michaelberk 

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

Enter the following formula in B1, then fill down:

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