Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

2
  • 1
    Import rather than Open the file use either the legacy import wizard or Power Query (Get&Transform=>from Text/CSV). And if you have users for whom this is difficult, you can always use a button to trigger a macro that brings up the select file dialog, and the rest is automated. Commented Apr 4 at 19:47
  • Yep, we tried that workaround, but unfortunately this is beyond our users... we're looking to get the data fixed upstream so the first column will not contain potentially-comma-bearing text data. But it looks like either no-one's encountered the "Excel inexplicably removes quotemarks from text" issue before or there's just no solution within Excel. I say we take off and nuke the whole app from orbit. It's the only way to be sure.
    – Jack Deeth
    Commented Apr 5 at 0:22