I have an Excel spreadsheet that contains various rows of data (some which contain carriage returns) and a cell at the end of each row that uses a formula to generate a JSON string. However, a problem has arisen where, if a row contains a cell that contains a carriage return, it will add double quotes, as well as quoting the entire row when I paste it into my text editor.
I’ve come to learn this is Excel’s default behaviour. How can I disable it or work around?
And don’t tell me to find a different solution. I would if I had the option but I’m working in a corporate environment, where I’ve been given the spreadsheet to work with.