Hi.
I just pasted from this email into calc.
Copy to clipboard.
Paste Special > Unformatted text. The text import dialogue opened and I
set delimiter as comma.
All imported as you asked.
steve
On 12/11/2018 08:32, vytas wrote:
Hi,
I have results arriving by e-mail containing a series of lines with a
structure as shown below.
"Vytas", "vy...@somewhere.com", "Jock Wadley Award" ,"Freddy
Someone", "dflghfsd"
"Vytas", "vy...@somewhere.com", "Beryl Burton Award" ,"Joan Someone",
"dflghfsd"
...
...
I need to paste this into a spreadsheet into five different columns.
Every paste method I tried has failed. The best I can get is that
everything gets pasted into the first field.
What am I missing?
Thanks,
Vytas
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy