Timeline for Excel removes delimiters from first field of "foreign" CSVs
Current License: CC BY-SA 4.0
8 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Apr 5 at 0:22 | comment | added | Jack Deeth | 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. | |
Apr 4 at 19:47 | comment | added | Ron Rosenfeld |
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.
|
|
Apr 4 at 17:41 | answer | added | Jack Deeth | timeline score: 0 | |
Apr 4 at 16:48 | answer | added | LPChip | timeline score: 0 | |
Apr 4 at 14:11 | answer | added | Paul | timeline score: 0 | |
Apr 4 at 13:45 | history | edited | Jack Deeth | CC BY-SA 4.0 |
added 183 characters in body
|
S Apr 4 at 13:27 | review | First questions | |||
Apr 4 at 13:53 | |||||
S Apr 4 at 13:27 | history | asked | Jack Deeth | CC BY-SA 4.0 |