[libreoffice-users] Pasting csv string into Calc

Hi,

I have results arriving by e-mail containing a series of lines with a 
structure as shown below.

"Vytas", "vytas@somewhere.com", "Jock Wadley Award" ,"Freddy Someone",  
"dflghfsd"
"Vytas", "vytas@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+unsubscribe@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