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


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

Enter the following formula in B1, then fill down: