Yes, this question has been asked before but only a workaround was ever found, which is not satisfactory for my situation. Neither is this solution satisfactory.
The question is, how can I change the default text qualifier in excel, from ", to say, a backtick (`). This would avoid the CSV file breaking, because I have many instances of unmatched double quotes in the text which stand for inches, and must be left as is. Thus with "24"" (24 inches), you can see the boundaries for the text are going to shift - which messes up the entire csv file. You can see that having `24"` solves the problem. But Excel doesn't seem to have an option to set your preferred text qualifier?
Edit: I'm well aware that the question has been asked multiple times before - so whilst it is strictly a duplicate, it is justified because all the other questions were already closed cases with accepted answers that were workarounds that are not satisfactory for me. I have certain constraints which I'll elaborate on below, but I opened essentially by clarifying that I needed a different kind of solution, ideally the most direct solution, and if not, something other than the answers already posed elsewhere.
For one thing, multiple mass search and replaces is going to increase the workload to something unacceptable. And the CSV files are provided to me already in such a way that I cannot distinguish quotes that stand for inches from quotes that serve as text boundaries in search and replace operations.
