Second author not exporting correctly

Hello

Having a problem when exporting from EndNote to Excel.

The second author doesn’t seem to show up and it’s all skewed like so:

Alqallaf AC, Drew W.; Render, Kandon P.; Patel, Katie A.

It is imported to EndNote as:

Alqallaf, Ali; Cates, Drew W.; Render, Kandon P.; Patel, Katie A.

I’m guessing it’s to do with changing the carriage returns to ‘; ‘ for Excel purposes but I could be wrong and I believe we need to do this for the records to show properly in Excel for our trackers.

Can anyone help?