Separating Authors
Whenever I extract my Zotero data to Excel, all the authors are lumped under one field and separated by a ";"... is there a way to have them appear in separate columns instead? I'm trying to gauge occurrences of authorship.
-
poettliCannot you set ";" as text delimiter when you import into Excel?
-
bwiernikYes, the best way to do this would be to use Excel’s Text to Columns function and specify ; as a delimiter.
-
poettliThe solution by @bwiernik works with LibreOffice too.
-
adamsmith(separate columns aren't an option since that would unbalance the exported table)