Forum Discussion
Adding a quote for each string AND a bracket around the entire cell?
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:
="["""&SUBSTITUTE(A1,",",""",""")&"""]"
