Upgrade StorageSeparating 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)
This is an old discussion that has not been active in a long time. Before commenting here, you should strongly consider starting a new discussion instead. If you think the content of this discussion is still relevant, you can link to it from your new discussion.