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...
Let's say you have such values in A1 and down.
Enter the following formula in B1, then fill down:
="["""&SUBSTITUTE(A1,",",""",""")&"""]"