On Wed, 24 Mar 2021 16:25:21 -0700, Tom Brennan wrote: >I had to do 2 things to make your sample output work with MS Excel 2010 >(yeah, it's old but I'm pretty cheap and it still works). > >#1 Remove the spaces after the commas. >#2 Double up the quotes in the foobar cell. I have no idea why. > >"=""12DE""","=""12DF""","=""12E0""","=""12E1""" >"=""12DE""","=""12DF""","=""12E0""","=""12E1""","=""foo""""bar""" > Extrapolating, the following works with LibreOffice:
"=""12DE""", "=""12DF""", "=""12E0""", "=""12E1""" "=""12DE""", "=""12DF""", "=""12E0""", "=""12E1""", "=""foo""""bar""", "=""x""""y""""z""" 4 quotes!? Didn't need to remove blanks. Are you working from doc? You seem to be guessing. Like me. Is MS Excel 2010 cheaper than LibreOffice 7.0.4.2? -- gil ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
